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 20170810010669ACirrus Design SR22T · Raton, NMOn August 10, 2017, at 1635 MST, a Cirrus SR-22T, N702N, registered to N512CQ LLC crashed while landing at Raton municipal airport, Raton NM while on a personal flight. Visual meteorological conditions prevailed at the time, a IFR flightplan was filed. The…Accident 20170810010359AHughes 369D · Villa Grove, COOn August 10, 2017 a huges 369D helicopter inadvertently contacted a powerline pole with its tail rotor, causing a loss of control and impacted the ground. The aircraft was substantially damaged. The pilot was the only occupant onboard and sustained serious…Incident 20170809016999IBeech 58 · Luray, VAOn 9 August, 2017, at approximately 2100, a Beech model 58 attempted to takeoff from Luray airport (lua) VA. At takeoff speed, the pilot could not pull back on the elevator controls. The pilot aborted the takeoff and exited runway 22 coming to a full stop…Accident 20170809012879A2017 Rose Herbert D. Pietenpol AIR Camper · Tower City, PAAirport surveillance camera recorded taxi, takeoff, stall and impact. Aircraft appeared to yaw several times during initial takeoff. Aircraft pitched up steeply, began to turn to the left, aircraft stalled, rotated left and struck the ground in a left wing…Accident 20170809012859AAir Tractor AT-802A · Galesburg, ILOn August 9, 2017, about 0730 central daylight time, an Air tractor AT-802A, N528MB, sustained substantial damage during a forced landing near Galesburg, Illinois. The commercial pilot was not injured. The airplane was registered to and operated under the…Accident 20170809012849ARockwell International 114 · Cairo, ILPilot attempted landed Cairo IL kcir runway 20. He landed gear up and overshot runway with the aircraft resting in a clearway at the end of runway. Aircraft was substantial damaged by rough landing and impact with the ground. Most damage sustained to left…Accident 20170809012839ACessna 172S · Wellston, OHOn August 9, 2017, at approximately 1220 EDT, a Cessna 172-S experienced a loss of engine power while maneuvering near Wellston, Ohio. The pilot and passenger sustained minor injuries, and the aircraft sustained substantial damage. The aerial observation…Accident 20170809011439APiper PA-22-150 · Trementina, NMOn aug 9, 2017 a 1960 Piper PA-22-150, departed (dht) at approximately 0845 towards sante fe, NM (saf). The plane was being operated by a private pilot on a personal flight. Visual meteorological conditions prevailed at takeoff, and marginal visual…Accident 20170809010349ACessna 195 · Newnan, GAIt was reported at Newnan Georgia (kcco) whitlock field on Thursday 08/10/2017 at approximately 1700 EDT a Cessna 195B registration number N2100C during takeoff roll left runway 14 to the left hitting a red runway light, 2 taxi signs on both side of the…Accident 20170809010339APiper J3C-65 · Camas, WA[privacy data omitted] Was PIC of N6048H, a PA-J3C-65 on August 9, 2017 at 1009 local. PIC was undergoing tailwheel transition training and was being observed by [privacy data omitted] holder of commercial and flight instructor certificates [privacy data…Incident 20170808016989IDiamond Aircraft Ind DA 42 · Prescott, AZDuring short field takeoff roll at about 70-72 knots, just before the rotation speed of 76 knots there was an aural warning and a yellow ecu caution indication for the left engine. The multiengine student manipulating the controls pointed to the yellow…Incident 20170808016979ISchnetzler Estill E JR Glasair III · Midland, VAAircraft landed on runway 33. PIC stated that he had three green indicated for the gear down and locked indicator prior to landing. As soon as the nose gear touched down, it started to shimmy and pulled the aircraft to the left. Pilot was braking and applying…Incident 20170808015779ICessna 310N · Palestine, TXAircraft departed bowie, TX for Palestine , TX. 20 southeast of dallas the pilot experienced total electricalfailure. He proceeded to Palestine, TX and initiated a gear up landing. No injuries to the pilot while the aircraft incurred minor damage to the…Accident 20170808012819APegasus Quantum · Fort Atkinson, WITuesday August 8, 2017 at 2005 local time, an experimental light sport weight shift aircraft registration number N56092 impacted into the rock river 300 yards east of runway 21 approach at Fort Atkinson Municipal Airport (61C) in Fort Atkinson Wisconsin.…Accident 20170808010329AKing John E JR Kitfox Series 6 · Reno, NVThe pilot stated he was practicing landings in his experimental kit fox aircraft. After touch down on runway 8, the aircraft veered to the right and the pilot failed to arrest the aircraft swing resulting in a ground looped and there was substantial damage…Incident 20170807016969IGulfstream Aerospace G-IV · Palm Beach, FLFlight crew declared an emergency and initiated air turnback to Palm Beach international (pbi) due to passenger report of smoke in the passenger cabin. Crew secured cabin and galley electrical systems, smoke cleared before landing and aircraft landed without…Incident 20170807016959IRobinson Helicopter R44 II · Dubuque, IAPilot was conducting agricultural dispensing operations and struck a wire in middle of the field. Power lines were running down middle of the field pilot was dispensing chemicals in. Pilot stated his rotor tip must have been closer to wire than he thought…Incident 20170807016949IKen Smith Rans S-6S · Elcho, WIAmphibious aircraft left rhinelander, WI for a pleasure flight. During departure the pilot stated that he was distracted by a fed ex aircraft approaching rhi and forgot to put the gear up. He proceeded to otter lake near Elcho, WI and attempted a south to…Incident 20170806017959IPiper PA 46-350P · Palm Springs, CADuring descent into psp, engine lost manifold pressure and oil pressure. An emergency was declared. Aircraft landed at psp without further incident. Two people on board. No damage. No injuries.Accident 20170806016939ARoger M Allen RA2 · Hector, MNPilot was taking off from the Hector airport on a local flight. Pilot completed first flight with no passenger nor issues. After he landed, he picked up the passenger and attempted to take off. He skipped several times before the aircraft began a high angle…Accident 20170806012809ALester Lydzinski NW-FREEDOM · Tranquility, NJWeight shift aircraft wings folded back on climb out causing loss of control.Accident 20170805024269ACessna 140 · Mt. Sterling, KYAt 2200 feet flying straight and level, pilot experienced loss of power. Pilot did an emergency landing in a field, was unable to stop the aircraft and went down a 70 foot steep grade where the aircraft came to rest. Aircraft substantially damaged. No post…Incident 20170805016929IPiper PA-28-151 · Fort Myers, FL08/06/2017 At approximately 01:45 zulu, a Piper PA-28, registration N75200, with pilot in command (PIC) en route from fort lauderdale executive airport (fxe) to immokale regional airport (imm) declared an emergency and diverted to Southwest Florida…Incident 20170805016919IBeech P35 · Williams, AZThe following is a statement FR0M the CFI who was pilot in command during the flight: [privacy data omitted] Here is the information you requested. [privacy data omitted] Had purchased an airplane and needed ten hours of dual to satisfy the insurance company.…Incident 20170805016909I2015 Kilian Baumann Kitfox Super Sport · Chickaloon, AKPilot was flying from sutton, AK. To King Ranch AK. Heard an unknown noise from engine. 10 min later had engine high temp light indication. Did a precautionary landing on sand bar. Inspected engine and found a broken starter drive tooth missing from fly…Incident 20170805016899IPiper PA-28-140 · Fayetteville, NCStudent pilot with all American aviation services was on a solo flight practicing landings on 08/05/2017. Winds on that day, as reported by fay ATC, were 260 degrees at 8 knots and the landings were being done on runway 22 at fay airport. Student pilot stated…Accident 20170805015769ALockheed P2V-5F · Pocatello, IDOn August 5, 2017, a Lockheed P2V-5F, air tanker was substantially damaged shortly after a departure from Pocatello regional airport (pih), Pocatello, Idaho. There were no injuries to the three people on board. According to the pilot-in-command (PIC), the…Accident 20170805012799APiper PA-28-140 · Pittstown, NJThe student pilot departed on a night flight with two passengers. The rear seated passenger was the only person having a recolecton of the accident. She stated that the pilot briefed the two passengers that he was preparing to land and put in flaps. She could…Accident 20170805012789ABurkhart Grob Flugzeugbau G102 Club Astir Iiib · Marion, OHAt just after 4 pm on Saturday August 5, 2017 a grob glider N102BK departed kmnn (Marion Municipal Airport Ohio) under tow from runway 31. After lift off the aircraft was reported to have a high nose up pitch attitude and began to cause the tow plane to jerk…Incident 20170805012379ICessna TU206G · Tavaras, FLOn Saturday August 5th around 1630 the pilot left from Tavares Seaplane Base (FA1) in one of their Cessna 206 aircrafts N171RS. He flew directly across the lake to pick up two passengers for a 30 min sightseeing tour at 1645 from the dock at the lakeside inn…Accident 20170805010319AChampion 7AC · Nampa, IDThis accident occurred during a flight training event. The first pilot (PIC seated in the back seat) was exercising the privileges of his flight instructor certificate by giving a flight review to the second pilot (trainee in the front seat) who was an ATP…Incident 20170804020649IMacdonald S-20 · Everett, WAAs part of the taxi sequence after landing the pilot reported that the right main gear collapsed.Incident 20170804017949IPiper PA-28R-200 · Searcy, AROn 4 August 2017 approximately 1800 local time at (ksrc) Searcy Arkansas, a Piper arrow N33759 was making a familiarization flight. During a slow maneuver the airman put the gear in the down position. The indication light did not illuminate a ?down and locked…Accident 20170804017939ABeech 19A · Palmer, AKStakeholder was flying with another aircraft performing local area familiarization The weather was blue skies (VFR) with no wind Stakeholder decided to land at the picnic strip at knik glacier The air strip is unimproved and covered with gravel and dirt After…Incident 20170804016889IEurocopter Deutschland EC 135 P2+ · Lubbock, TXAt 1530 LCL; N459MT, an EC-135 helicopter was repositioning on the university medical center helipad (TA79) and had a tail strike on the tail bumper of the fenestron striking the top rail of the 4 foot high chain link perimeter security fence. The solo pilot…Incident 20170804015759IPiper PA-28-180 · Columbia, MSAirman [privacy data omitted] is a private pilot [privacy data omitted] who owns N5191L a Piper PA-28-180 aircraft. On Friday August 4, 2017 at approximately 1500 local time [privacy data omitted] departed Columbia, MS airport (0R0). He conducted three left…Accident 20170804012829ACessna A188B · Marshall, MOPilot reported loss of engine power on climbout from rwy 18 at kmhl, resulting in a forced landing in an adjacent cornfield. The pilot was conducting an agricultural application flight under 14 CFR 137 at the time of the accident. Winds at the time of…Accident 20170804012779ACessna 172F · Drexel, MOPilot attempted to take off down hill from an unimproved dirt surface located at a construction site. The top soil had been removed down to a clay surface. The surface was very hard and dry at the time. As the pilot rotated, the aircraft stalled and impacted…Accident 20170804010679ARans S-9 Chaos 2017 Terry F Bolstad · Hackney, IDAccident occured during experimental aircraft's madien flight. Shortly after takeoff after departing runway at an altitude of about 100-150 feet above runway, pilot stated he experienced difficulty lowering the nose. While the pilot attempted to regain…Accident 20170804010309ACessna 208B · Mulino, ORPIC stated aircraft had no discrepancies. After dropping sydivers pilot began descent east of airport with power at idle, prop full forward. At 2500 feet pilot added power to reduce rate of descent entering pattern at 1500 feet. Pilot states he applied 10…Accident 20170803017929ARobinson Helicopter R44 II · Solomon, AKPilot stated he was lower than he should have been and lost situational awareness when working with the GPS. He might have pushed forward on the Cyclic as he leaned forward to the GPS unit. The first indication of a problem was the helicopter slowing and…Incident 20170803016879IBell 407 · Midlothian, TXCrew was training a stuck pedal maneuver when the main rotor blades contacted the left hand vertical fin.Incident 20170803016869IEmbraer S A ERJ170-200LR · Washington D.C., DCOn August 3, 2017, about 1511 eastern daylight time, (1911Z), republic airline, inc., flight 4578, an Embraer 170-200, N430YX, experienced severe turbulence during approach resulting in minor injuries to a flight attendant. The flight attendant was securing…Accident 20170803015749AMichaelian Marshall S IV-P · Rio Linda, CAN420M a Lancair IV-P experimental amateur-built aircraft (turbine powered). Crashed under unknown circumstances into a residential backyard. Power lines were also impacted. No post fire, no injuries on the ground, the pilot was the only soul on board suffered…Accident 20170803015729ABeech D17S · Colorado Spring, COOn August 3, 2017, at approximately 1110 hours (MST), N44562, a Beechcraft D17S staggerwing sustained major damage during landing rollout at Colorado Springs municipal airport (kcos), CO. Weather at time was visual metrological condition (VMC). There were two…Incident 20170803015719ICessna TU206G · Minden, NVAshlie rynn caceres. Time in sport: 6 years, total number of jumps: 2463, last 30 days: 55, last 12 months: 354. Uspa D-3250, member 250534, instructor ratings: TAN-1, coach-c. expiry 08/31/2017 Skydive lake Tahoe, 1128 airport road, Minden, Nevada 89423.…Accident 20170803012769AEurocopter AS 350 B3 · Big Delta, AKPilot landed too close to a piece of equipment. Rotor blades struck steel rail on the equipment.Accident 20170803012759AAutogyro MTO Sport · Mentone, INOn August 3, 2017 at approximately 10:00 eastern daylight time, an Mto Sport experimental gyroplane, N571UJ, registered to and operated by a sport pilot, received substantial damage when it rolled onto its side during landing on runway 36 at the Mentone…Accident 20170803012749ACessna 180A · Willow, AKPilot stated he did not set his approach up soon enough for a glassy water landing, as a result the aircraft hit the water hard and flipped over causing substantial damage.Accident 20170803012709ACzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCOn 8/3/2017 student pilot was performing landings and takeoffs, student stated that during one of the approches to land the canapy came open. He completed the landing, closed the canapy and took off. On the next approch to landing the canapy again came open.…