FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Accident 20170920011339ACessna 150G · Rhine, GAOn September 20, 2017 at about 06:15 local time pilot departed Private Airport. Witnesses heard and saw aircraft depart private grass airstrip to the southeast. They said he made a left 360 degree turn before the lights of the aircraft dissapeared followed…Incident 20170919019589IPiper PA-31-325 · Charleston, WVPilot took off from crw. Everything was good but a little slow. At rotation heard a clunk sound. Tower confirmed the nose landing gear was not retracted. Performed emergency procedures for landing gear emergency but was unable to get the gear down and locked.…Incident 20170919012229IPiper PA-28 · Atlanta, GABoth pilots chief flight instructor and student pilot have attested that prior to takeoff there were no known deficiencies of the nose landing gear on aircraft N258SB. The aircraft had two landings prior to the final approach at kpdk. No hard landings…Incident 20170918019579IBeech F33A · North Canton, OHAircraft landed at cak on runway 23. During landing rollout the aircraft drifted to the right side of the runway hitting a taxi-way light. Pilot recovered, and the aircraft completed its taxi to parking.Incident 20170918019569ICzech Aircraft Works Spol Sro Zenair CH 701 Stol · Clearwater Beac, FLOn September 18, 2017, at 1250 EDT, a Czech Aircraft Works Spol Sro, Zenair ch 701 stol, N61KW, registered to pragway us inc., made an emergency landing after experiencing engine power loss, on sand key beach, Clearwater beach, FL, while on a recreational…Accident 20170917022419APiper PA-28-161 · El Cajon, CASan diego ? Gillespie Field, CA (see): N2587X, P28A, performing pattern work, touch and goes on 27L, Gillespie Field. Aircraft was in the right traffic pattern when cleared to land 27L. During descent and turning right base, aircraft lost power, pilot /…Accident 20170917021699ABalloon Works Firefly 8B-15 · Salinas, CAOn 09/17/2017 at approximately 0656 PDT, N3285T, bell 47G-5, operating under 14 CFR part 137 agricultural aircraft operations was spraying a field near Salinas California. In a statement from the pilot: he took on about 85 gallons and took off to the north…Accident 20170917020839ACessna 177B · London, OHCFI was performing private pilot training with a student pilot. Aircraft was measured for fuel before flight using fuelhawk overwing measuring stick. Calibration table was used. Crew estimated 25 gallons on board with an estimated 11 gph burn at mixture and…Incident 20170917019539IPiper PA-28-181 · Deer Valley, AZAircraft operated by trans-pac (bird acquisition LLC) 141 pilot school (fqas) at Deer Valley Airport (dvt). Student was on solo flight with 38 hours total time. Third class medical student certificate #4023898. During a hard landing at Deer Valley Airport…Incident 20170917019529IDassault DASALT-MYSTFA · Appleton, WIOn 9/17/2017 a clear VFR day winds 280 at 10 knots. At approx 1855Z aircraft was cleared to land runway 21. Prior to landing the crew ran the before landing checklist and noted the left anti-skid indicator not to light up. Crew tested the anti-skid system…Incident 20170917011859ICessna 310L · Englewood, COOn September 17, 2017, at approximately 1245 hours (MST), N3344X, a Cessna CE-310 sustained minor damage on landing rollout Centennial Airport (kapa), CO. N3344X sustained minor damage after the aircraft had touched down and during landing rollout, the…Incident 20170916024669ICessna T210J · Mesa, AZOn 9-18-2017 the pilot reported a loss of power upon the aircraft leaving the runway. The pilot stated he had just retracted the landing gear when he lost power, he stated he did not have time to extend the gear back down and the aircraft settled back onto…Accident 20170916024449AReportGyrocopter was first observed by friends as rotating out of control and crashed resulting in the death of the pilot.Accident 20170916021689ACessna A185E · Talkeetna, AKThe pilot flew to the Cache Creek Gravel Strip which is approximately 25 miles west of Talkeetna, Alaska. The pilot received wind updates while in the pattern from another aircraft that had landed 10 minutes earlier on the Cache Creek Gravel Strip. The winds…Accident 20170916020829ABell 206L-3 · Ancho, NMOn 9-16-2017 at 16:30 MST, a Bell 206-L3 helicopter, N213TV, registered to lin television corporation, while in cruise flight, was involved in a fatal accident. The aircraft was returning to albuquerque, NM from roswell, NM. No flight plan was filed. Flight…Incident 20170916020819IPiper PA-28-161 · Farmingdale, NYDuring student training and thrid touch and go pilot was on the upwind 450-600 feet MSL when there was a noise and what was felt like a rupture. Something red flew over the windshield and the aircraft immediately lost thrust and viberation of the rotation of…Accident 20170916020589APiper J3C-65 · Hanover, PAOn September 16, 2017 at approximately 2049Z a Piper J-3 cub (N38365) crashed into the driveway of 239 mckenzie rd in Hanover twp, PA. The FAA regional operations center (roc) received the call and was given the following information. The roc reported…Accident 20170916019519AMooney M20C · North Branford, CTThe aircraft was enroute from Robinson airport (4B8) in plainville CT. To gabreski airport (fok) on long island n.y. At approimately 1:00PM local time the neightbors in the area of the crash reported hearing a loud thud. Sometime later a resident went on a…Accident 20170916019509ABeech 35 · Marathon, FLAircraft N3187V was conducting a surveilance flight when the pilot experienced an uncommanded engine shut down between FL800' and 1000'. The aircraft was landed in the water approximately 3 miles north of the west end of the 7 mile bridge and 10 miles west of…Incident 20170916019499ICessna 172E · Sherman, TXThe airman had purchased the airplane three days earlier in the state of California and was flying it home to the state of new york. According to the airman, while enroute to the Sherman municipal airport (kswi) for a fuel stop, smoke appeared in the cabin…Accident 20170916019489ACessna 172M · Gallitin, TNEntered downwind pattern for runway 17 for touch and go. Completed first touch and go reported his position turned crosswind for runway 17 entered downwind, on midfield engaged carbheat and reduced power to 1700 rpm's added 10 degrees of flaps, started decent…Accident 20170916019469AGaddis Michael Exec 162-F · Plymouth, INPIC and passenger departed C65 and approximately 1645 EST. While airborne approximately 15 minutes, PIC and passenger heard strange noise. PIC attempted to return to C65 when he noticed his engine rpm's redline and his rotor head speed decrease. The PIC…Accident 20170916016039ARudberg Todd W Vans Acft RV8 · Manzanita, ORShortly after touchdown on landing rollout runway 33 approximately 1000 feet from the threshold, aircraft struck two elk before coming to rest on the runway approximately 1500 feet from the runway threshold. Aircraft sustained substantial damge. No injuries…Incident 20170916011849IBellanca 7KCAB · Centennial, COAt appx 1630 on 09/16/2017, pilot in command of N53959, giving dual instruction to atp-rated pilot for tailwheel endorsement, lost control of the aircraft during a demonstration of rudder control. Gusty crosswind weather conditions in VMC prevailed. The…Accident 20170916011649ACessna 208B · Sedona, AZ(Pilot statement edited for relevant content) I was the PIC of N786WW (westwind caravan explorer 3) after an uneventful landing on runway 03 at sez, I taxied the plane on taxiway A2 to taxiway a and was instructed by UNICOM (123.0) "westwind explorer 3 follow…Accident 20170915024389ABeech A36 · Mcalister, OKPilot was inbound for runway 20 at mcl and had desended to FL1400 AGL when he experienced a loss of power. Pilot then attempted to land on runway 2. About 200 yards short of runway 2 the pilot landed in a hay field. The landing gear colapsed on landing roll…Accident 20170915020809AAirmax Construcoes Aeronautica SEAMAX-M22 · New Fairfield, CTPilot stated that he performed a normal water landing. After floating in the water on candlewood lake, the aircraft hull started to take on water. The pilot and passenger left the aircraft and were picked up by a near by boater. The partially submerged…Accident 20170915020789ACessna T210N · Watsonville, CAOn September 15, 2017 at approximately 13:00 PDT, N5391A, CE-T210N landing at Watsonville Airport (wvi). In a statement from the pilot: just before landing wind was variable at 5 and all the feel of landing including flare was uneventfull and when nose gear…Accident 20170915019409AAir Tractor AT-502 · Union City, TNThe commercial pilot was the sole occupant and pilot of aircraft N4531K that departed fulton county airport, Kentucky, Friday, September 15, 2017, at 0915 local, 1715Z, while en route to Union City, Tennessee, to perform a part 137 agricultural seeding…Accident 20170915019399ACessna 172N · Lynchburg, VAAccording to the statement from the pilot: pilot made a normal approach into Falwell Airport with extra speed. Pilot ballooned the aircraft during touchdown. Pilot then executed a go-around by adding full power while maintating positive control of the…Incident 20170915019389IPiper PA46-500TP · Bethany, OKOn September 15, 2017 at approximately 1642 CST, the pilot of a Piper PA-46, reported a large bird had struck the left wing/flap surface of the aircraft while on approach to runway 17L of wiley post airport located in Bethany, Oklahoma. After striking the…Incident 20170915019379IMooney M20F · Crystal River, FLPilot departed witman field in stuart, Florida (sua) heading towards tallahassee, Florida (tlh) enroute the aircraft lost power and the pilot operated it until the aircraft had total electrical power loss. The pilot diverted to Crystal River, Florida (cgc)…Accident 20170915016029AParks Richard A Starduster SA-100 · Southfields, NYOn September 15, 2017, at 1312 EST, a starduster SA-100 experimental biplane, N1356W, [privacy data omitted] was enroute from chester airport (ksmc),chester, CT, to warwick airport (N72), warwick, NY, in visual meteorological conditions. Due to smoke, a…Accident 20170915011259ACirrus Design SR22 · Glenwood Spring, COOn September 15, 2017, at approximately 1921 MDT, N462SR, a Cirrus SR22, departed fort collins-loveland municipal airport (fnl) in fort collins, Colorado with the pilot and 3 passengers en-route to canyonlands field airport (cny) in moab, UT. The PIC…Incident 20170914021679IDehavilland DHC-6 Twin Otter · Acampo, CAA single parachute fatality occurred at approximately 1300 PDT at Lodi parachute center Lodi, CA. Parachutist [privacy data omitted] exited airplane N97DZ wearing a swift 2 squirrel wingsuit and a wing brand rig with a strom brand parachute. Parachutist…Accident 20170914021669ABeech 95-B55 (T42A) · Statesville, NCBased upon written statements, during the landing phase of flight, the aircraft impacted the runway three times hard. After the third impact to the runway, the pilot applies power to execute a go-around and lands the aircraft without further incident. The…Incident 20170914020779ISchweizer G-164B · Twin Falls, IDThe pilot was spraying a field east of Twin Falls Idaho. During a spray run the pilot experienced an updraft from a thermal and attempted to correct for it with forward pressure on the stick. The thermal suddenly stopped and the pilot was not able to correct…Accident 20170914019369ABeech C23 · Machias, METhursday morning , September 14, 2017, pilot prepared a cross country flight departing kaug to Kmvm, klrg and back to kaug. Pilot had gone over his flight plan with his flight instructor at Maine Instrument flight. Pilot contacted flight services to file his…Incident 20170914019359IZapf Rodney L ZAPF-KITFOX III · East Dubuque, ILThe pilot stated to the responding inspector that he was water taxiing the aircraft, an experimental amateur built Kitfox iii, when the floats struck mud in the backwaters of the Mississippi river near East Dubuque, IL. The aircraft nosed over into the water…Accident 20170913020769ACessna 210G · Hallsville, MODuring climb out from kcou, the engine completely stopped operating. After attemps to restart the engine failed, the pilot performed an emergency forced landing in a corn field with the gear retracted.Incident 20170913019349IPiper PA-34-220T · New Orleans, LA09/13/2017-17:40Z- left main gear would not retract after departure, returned and landed RWY18R. 09/14/2017- Made contact with PIC. After returning to knew PIC stated he decided to fly the aircraft from knew to khum for maintenance. Landing gear was not…Accident 20170913019339ABombardier CL-600-2B19 · Charlotte, NCOn September 13th, 2017 at 1545 (EDT) a Bombardier CRJ-200 operated by psa airlines flight 5233 collided with a baggage tug operated by psa airlines during taxi. The airplane received substantial damage to the left wing, the tug canopy section was damaged.…Accident 20170913016019ACessna 402B · Nantucket, MAHistory of flight On September 13, 2017, about 0723 eastern daylight time, a Cessna 402B twin-engine airplane, N836GW, owned and operated by f/v theresa madeline, inc. of centerville, Massachusetts, sustained substantial damage upon impact with the ground…Accident 20170913016009AMiller Steven M RV6-A · Elbert, COWhile trying to land at CO15 (Kelly Airpark, Elbert, CO) N812SM departed runway 26 and struck a cistern pipe sticking out of the ground 136 ft to the south of the runway with the right wing puncturing the leading edge. The aircraft continued through the field…Accident 20170913010639AParker Toby W Highlander · Burns, ORAirman was attempting to land on a dry lake bed and struck sage brush with the right landing gear. This caused loss of controll and the right wing impacted the ground causing substansial damage.Accident 20170912022519APiper PA-11 · Skwentna, AKPilot was landing on gravel bar while practicing a tail high landing. Swirling wind coupled with aggressive braking caused aircraft to flip over nose. Damage to propeller, windshield, rudder, wing ribs, lift strut, leading edge wing fairing.Accident 20170912019322ABoeing 737-924ER · Los Angeles, CAUal 447 while taxiing westbound on twy c, struck the right horizontal stabilizer of an air Canada B-767 with its right winglet, as it was being towed onto gate 69B. Cala cmo and cala flight safety are investigating. Report will be amended once crew…Accident 20170912019319ACessna 210B · Kinsley, KSThe personal flight, with the owner as the sole occupant onboard, was landing at the Kinsley airport in Kinsley, Kansas airport (33K) on September 12, 2017 at approximately 1039 CDT when the accident occurred. The aircraft was seen by numerous witnesses…Accident 20170912019309ABeech 35-A33 · South Bend, INN9368Y, a 1960 Beech N35 bonanza, lost power while on final approach to runway 9R at the South Bend international airport in South Bend, Indiana. The pilot attempted an off airport landing outside the airport perimeter near the approach end of runway 9R. The…Incident 20170912019299IBeech 1900D · Grand Canyon, AZOn September 12, 2017 at approximately 1910MST, N886MA a beechcraft/raytheon BE-1900D aircraft operating under FAR 135 by maverick airlines, inc. experienced a collapsed nose wheel landing gear upon landing at Grand Canyon national park airport (kgcn). The…