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.
Incident 20120616009819IBellanca 17-31ATC · Moriarty, NMOn landing on runway 26 at 0E0, pilot landed and then lost control on the rollout. After landing the aircraft began to veer right. Pilot corrected with left rudder. Decided to go around and applied full power. Aircraft departed the leftside of the runway at…Accident 20120615015959ARemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDPilot lost control of elevator system. Tried to land at W54 (dmw) and lost control of aircraft on final to runway 16. Aircraft dove into ground 40 ft before runway and disintegrated on impact.Accident 20120615015509ACessna 170 · Biddeford, MEAircraft was on a VFR flight from the Biddeford, Maine airort (B19) to the sanford municipal airport, sanford, ME (sfm).preflight, engine start, run-up and takeoff were normal. On climb out from B19 at appoximately 1100 feet MSL pilot stated the engine just…Incident 20120615013639IBeech B90 · Sturtevant, WIAfter landing on runway 08L left main landing gear collapsed. Pilot appled power and got the aircraft airborne only to stall. The aircraft landed north of the runway on the right main landing gear facing north. The right main landing gear then collapsed. The…Accident 20120615013629AAir Tractor AT-502 · Ipswich, SDOn June 15, 2012 at 1645 local time an Air tractor 502 registered to tri-county ag service, inc. was involved in an aircraft accident, when the aircraft departed (180 degrees heading) a private strip (2SD9) and failed to develop lift and rolled off of the end…Accident 20120615012039ACessna 172M · Churchville, MDPilot was on landing rollout on runway 01, when a tractor which was mowing grass started to cross the runway. There is a crest on this runway and you cannot see from one end to the other. Neither saw each other until it was too late and the aircraft caught…Accident 20120615011909APeterson-Feder-Splinter Starduster TOO · Lake Dallas, TXPilot stated that he tookoff from 30F with a friend flying around lake lewisville for approximately 15 minutes then returned to 30F for some touch and go's. he stated that they had accomplished the first touch and go without incident. During the second touch…Incident 20120615011839IDehavilland DHC-6-200 · Plattekill, NYName of jumpers: david winoker, student and aleksandr chulsky, instructorexperience and training: winoker, first jumpchulsky, uspa "d"licensed coach, tandem instructor current through 11/2012.club affiliation: uspa, skydive the ranch, Gardiner, nydescription…Incident 20120615011309IWhite NEW Standard D-25A · Atlanta, GAAircraft side slipped to land with cross wind component. All three wheels were on runway at 30 mph when the aircraft turned left (METAR: VBR5KT).pilot initially tried to use rudder instead of brake to turn right, to get back on course down the runway. Pilot…Incident 20120615010809IPiper PA-28R-201 · Warwick, RIDuring cruise from mvy to pou, the engine started to vibrate severely then siezed. The pilot diverted to oqu glided and then landed safely with no injuries. The number three cylinder found to be separated from the engine case.Accident 20120615010799ARoetman Ryland K JR Eagle · Rexburg, IDDuring a practice session the pilot was performing rolls above the runway, the aircraft seemed to loose power and crashed on the golf course.Accident 20120615010049APiper PA-28-181 · Sheboygan, WIPilot attempted to take off from runway 21 at ksbm. Southeast winds gusting to 18 KTS existed at the time of departure. Due to incorrect crosswind correction by the pilot, directional control was lost. When it became clear that he was going to depart the left…Accident 20120614021799ARobinson Helicopter R22 Mariner · Oak Island, NCAtlanta control center reported a helicopter crashing into the ocean about .3 miles off of the coast of Oak Island, NC. It was reported that there were minor injuries and the aircraft had been towed to shore. The pilot was reported as [privacy data omitted].…Accident 20120614013209ACessna 560XL · Brumley, MOAircraft struck a deer while landing at aiz causing damage to the nose landing gear actuator and surrounding nose wheel well structure.Accident 20120614012679ACessna 150M · Gulf Shores, ALOn June 14, 2012, N9119U, a Cessna 150, was on a training flight for a certificated 141 pilot school. After approximately 1 hour of flight training maneuvers, the student and the flight instructor proceeded to kjka to land. According to the flight instructor,…Accident 20120614012299ACessna 172K · Tupelo, MSOn June 14, 2012 at approximately 2000 local time a Cessna 172 was cleared to land on runway 36 in Tupelo, Mississippi. The pilot reported that during a night cross-country flight from olive branch, Mississippi (olv) he landed hard and bounced on touch down…Incident 20120614012289ICessna TR182 · Mckinney, TXOn June 14, 2012, on approach to Mckinney airport (tki), PIC, [privacy data omitted] failed to lower his landing gear which resulted in a gear up landing. With power at idle on downwind from parallel to end of landing runway. Practice of emergency landing,…Accident 20120614012279ACessna TP206A · Alpine, TXOn June 14, 2012, approximately 1729 CDT N4630F, a Cessna 206, was returning to the Alpine airport (E38) after performing aerial survey. The flight was conducted VFR without a flight plan. N4630F landed on runway 19 at E38 was tracking on centerline when a…Incident 20120614011389ITierra Verde, FLIntended to take his entire family, one at a time for a ride. When I asked [privacy data omitted] how he received a weather briefing, he advised me that he listened to the automated boating forecast. The wind forecast was for less than ten knots. Next,…Incident 20120614011329IMooney M20C · Selma, ALAircraft with single pilot was in the traffic pattern at (sem) practicing approaches. On approximately the sixth approach, the pilot stated he accidentally failed to extend the aircrafts landing gear. Aircraft slid a short distance and came to a stop with the…Incident 20120614010039IEmbraer-Empresa Brasileira De ERJ 170-200 LR · Minneapolis, MNOn climb out from msp right engine failed due to bird ingestion. Aircraft returned to msp and landed without incident. No injuries were reported. Right engine was replaced.Accident 20120614009669AYakovlev YAK 52 · Fort Collins, CO[privacy data omitted] Landed his yak 52 N76YK on runway 15 at the Fort Collins - Loveland municipal airport June 14, 2012 at approximately 14:50 local. On the landing role the nose gear collapsed damaging the fuel line and an engine fire ensued causing…Accident 20120614009639AEvektor-Aerotechnik Sportstar Plus · Eri, COInstructor [privacy data omitted] certificate number [privacy data omitted] was conducting soft field take offs with student pilot [privacy data omitted] in a Sportstar Plus aircraft N617EV at the Eri Municipal Airport runway 33 on 06/14/2012 at approximately…Accident 20120613012689ADehavilland DHC-2 MK. I(L20A) · Talkeetna, AKOn June 13, 2012 at 1908 adt, N121KT tookoff from tka when at 1500 MSL, the pilot experienced a rough engine and a loss of power. The pilot turned back to tka and performed emergency procedures to restore power. The engine continued to run poorly to not at…Incident 20120613012669IGates Learjet 35A · Anchorage, AKDuring a post-maintenance test flight:shortly after departure reported a spoiler unsafe indication and dumped fuel nw of the airport to avoid overweight landing. Then declared an emergency after selecting gear down and getting a landing gear unsafe indication…Accident 20120613011269APiper PA-28-180 · Ocilla, GAOn June 13, 2012 aircraft N9238J left livingston municipal airport (8A3) livingston TN ferrying for maintenance to clearwater air park clearwater FL (kclw). Pilot heading approximately 12 miles south of fitzgerald municipal airport (kfzg) when he felt the…Incident 20120613010219ICessna 172L · Opa Locka, FLFSDO 19 was notified at 0900 on 06/13/2012 of an aircraft incident at the Opa Locka executive airport (kopf). Three inspectors were dispatched to conduct an initial investigation. The asi's arrived at kopf at 1000 hrs. And where escorted runway 9R by airport…Incident 20120613009909IPiper PA-24-250 · Bakersfield, CAAircraft departed cno, climbed to 8500 ft using fuel from the rt main tank. In level flight, pilot changed to the lt main tank. Approx. 10 min. After changing to the lt tank, the engine quit. Pilot elected to atempt a landing at L45, but was unable to reach…Accident 20120612013159ARobinson Helicopter R44 II · East Wenatchee, WAThe pilot and pilot rated passenger were conducting cherry drying operations in a Robinson R44 ii helicopter. They had finished a north to south pass and were making a left 180 degree turn when the main rotor struck a power line located approximately 40 feet…Accident 20120612013119APiper PA-38-112 · Mount Vernon, MORepositioning flight was conducted from aurora, MO (2H2) to the pilot's farm on the outskirts of Mount Vernon, MO, under VFR. The PIC directed his farm hands to mow down tall grass for a landing strip. The strip was oriented east-west and was approximately…Accident 20120612013009AMooney M20F · Hooker, OKOn June 12, 2012, at approximately 1515, N6455Q, a Mooney M20F, crashed in a field off the departure end of runway 17 at Hooker Municipal Airport in Hooker, Oklahoma. The pilot stated he took off and started losing power as he retracted the gear but could not…Accident 20120612012649ABowles Chris Kitfox 5 · Jonesville, KYAircraft lost directional control on takeoff and departed runway 13 to the left. Aircraft ended up approximately 100 yards down an embankment facing the direction of takeoff.Incident 20120612012329IAir Creation GTE · Albuquerque, NMOn June 12, 2012, at 0736 MDT, N971EW, an experimental light sport aircraft, an Air Creation model Gte, a single engine weight-shift controlled aircraft, [privacy data omitted] was on a flight to maintain his currency by practicing take-offs and landings at…Accident 20120612011619AStemme S10-VT · Warner Springs, CAAfter carefully reviewing the factors surrounding this accident, the investigating inspector feels the major reason for this accident were the winds. The wind direction during that flight was "variable" at 10 to 12 knots gusting to over 15 knots. Pilot…Accident 20120612011439ACessna C185 · Winnett, MTOn 06/12/2012 at 2034 MDT a Cessna 185 landed on highway 200 near mile marker 140, 3 miles east of Winnett, MT. During the landing the aircraft sruck 4 electrial wires which crossed highway 200. Pilot stated to the petroleum county sheriff that the aircraft…Incident 20120612011089IBeech 76 · Torrance, CAOn June 12, 2012 @ 1805PDT, N6704X Beech 76, landed at Torrance airport (ktoa) with the right engine not running and right propeller feathered.Incident 20120612010029IRobinson Helicopter R44 II · Dayton, WAN442RN, a R-44 helicopter received minor damage to the spray-boom when it contacted a power-line while conducting 137 operations near Dayton, Washington. Damage was limited to the spray-boom and chin bubble. The aircraft was safely landed and there were no…Accident 20120611027649ABoeing 737-724 · Lake Charles, LAThe flight was a part 121 flight scheduled from kiah to klga. Passing FL230 enroute to 350 the aicraft encountered severe turbulence. Three flight attendants were injured. One was knocked unconcious and had numerous broken bones.Accident 20120611015119ACessna 182A · Colfax, WAAircraft was on personal flight from lewiston, id to spokane, WA. Just north of Colfax, WA engine lost power. Pilot landed on north-south highway approximately 4 miles north of Colfax, WA. During landing aircraft clipped a power wire with the vertical…Accident 20120611011629AAyres S2R-G6 · Riverton, WYOn June 11 2012 at approximately 0720 hrs MDT, N70WY, an Ayres Corporation model S2R-G6 turbo thrush aircraft was substantially damaged during an emergency landing near Riverton Regional Airport, (kriv) WY. The sole occupant on board was not injured. Weather…Accident 20120611010629ANorth American AT-6C · Delmar, DEAircraft was landing in the aircraft owners, 1370' farm field. The aircraft touched down in the designated field then overran it and entered an onion field in which the ground was much softer. After traveling approximatly 200 feet in the soft field the…Incident 20120611010529IRaytheon A36 · Gladwin, MIPilot noticed that his electrical instrumnets were begining to fail while he was in cruise flight. He then experieced total electrical failure and the autopilot kicked off. The pilot paniced and landed at gladwinn airport gear up. He initially made an attempt…Accident 20120611010509AEvektor-Aerotechnik Sportstar · Greenwood, INThe student pilot was conducting his first supervised solo. On the third takeoff he had over corrected with right rudder for the left turning tendencies of the aircraft. He proceeded to over correct again with the left rudder in an attempt to straighten the…Incident 20120611010229ICessna 172S · Gosnold, MAOn landing aircraft propeller and left wing tip struck the ground bending propeller blades and damaging wing tip.Incident 20120611010209IPiper PA-28-140 · Butler Twp., PAPilot departed burlington VT. On June 11, 2012 at 1430 on a VFR flight to hazleton airport (hzl) pa. Pilot departed with full tanks of fuel for the flight. During the flight the pilot switched tanks, to balance fuel, the pilot continued the flight on the…Accident 20120610018649ABuckeye Breeze · Leechburg, PA[privacy data omitted] Was attempting to land in a field adjacent to his home when the aircraft struck a tree approximately 25' high.[privacy data omitted] Does not hold any pilot certificateIncident 20120610013269IEstumkeda Ltd DBA Micco Acft MAC-145B · Taos, NMOn June 10, 2012, at 10:00 MDT a micco MAC-145, N201MA, [privacy data omitted] had the tail wheel retract links collapse on run up during an instructional flight. Visual meteorological conditions prevailed at the time and no flight plan was filed. The…Accident 20120610013039ACessna 172H · Moscow Mills, MODuring take off from runway 27 at greensfield airport (M71) near Moscow Mills, MO. N3736R climbed to approximately 5-10 feet and was pushed back onto runway by gust of wind. The pilot elected to abort the takeoff attempt and began applying braking action.…Accident 20120610012989AAirbus Industrie A320-212 · Minneapolis, MNDelta air lines flight 888 experienced clear air turbulence on approach into msp. Flight attendant was in the aft galley when the turbulence struck. He stated he was airborne for a short time. His legs impacted the floor, breaking his ankle. Flight attendant…Incident 20120610012849IRebich Charles L Pitts S1S · Phoenix, AZPilot bounced aircraft during 3 point landing, losing control and allowing nose to impact runway. On rollout aircraft departed runway to the left colapsing right main gear, draging right wing and again going vertical on it's nose before falling back to the…