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 20090801048309AEurocopter EC130B4 · Little Deer Isl, MEAirman is a resident of monaco, operating Eurocopter EC-130 registered in isle of man uk. Airman holds FAA issued private pilot certificate rotorcraft helicopter & airplane single engine land. Helicopter departed fantail of airman's personal motor yacht "lady…Accident 20090801048289ABoeing A75N1(PT17) · Livermore Falls, MEAirman was departing bowman field (B10) in Livermore Falls, ME. During latter stages of takeoff roll and climbout airman noted that engine was not producing full power and engine was slowly losing power. With insufficient altitude to make return to airport…Accident 20090801048249ALet L-13 Blanik · Sparta, NYOn August 1, 2009, a student pilot soloing a glider and during a climb entered a stall, recovered and subsequentally entered another stall which resulting an impact with the ground.Incident 20090801048039IPiper PA-12 · Anchorage, AKLeft main gear collapsed on landingAccident 20090801047969APiper PA-18 · Skwentna, AKThe airman made two low recons over the landing area prior to landing to assess conditions and used his GPS to determine the wind direction and velocity. He made the final approach into a light headwind over a downsloping hill. His left landing gear and belly…Accident 20090801018259AAirbor EDGEXT912L · Lihue, HI1. See attached for narrative. 2. Item #15, type of aircraft: light sport weight shift. 3. Item #23, weather briefing source:mr defino had flown several times earlier in the day and did not get a weather briefing. On Saturday, 08/01/2009, a weight shift…Accident 20090801016469AAmtr STARDUSTER2 · Earlham, IA(-23) A witness observed the flight prior to the accident and stated that the aircraft took off and did a roll. It then did a loop with too low of an altitude. The pilot couldn't pull out of the loop and the aircraft struck the ground. Emergency personnel…Incident 20090801013029ICessna 172K · Hebron, NEWhile taxiing back to his hanger after refueling, the pilot of a 172 allowed his wingtip to come in contact with the rudder of a parked cherokee 140. The resulting damage to the 140'S rudder was reported as minor and the 172 encountered little or no damage.…Incident 20090801012999ICessna 182F · Boise, ID(-23) Shortly after departure, the pilot was contacted by another pilot on the ground who stated the CE-182 nose gear appeared to be turned 90 degrees. A fly by was made and ground personnel confirmed this. The pilot stated the takeoff was uneventful and was…Accident 20090801012619AEnstrm F28F · Terrell, TX(-23) On August 1, 2009, at 1040 central daylight time, a PA-22-135, N8602C, operated by [privacy data omitted] a private pilot, received substantial damage when the aircraft while landing, veered to the left of the runway, flipped over and came to rest…Accident 20090801012319AAmtr RV6 · Caldwell, ID(-23) A pilot/mechanic eye witness observed the RV-6 depart runway 12. During the initial climb-out, the eye witness stated the engine started to make popping noises. He then observed the RV-6 level off at an altitude of 200' AGL and immediately turn to a…Accident 20090731049239ABingham Chu Rotorway 16 · Kennesaw, GAHelicopter was hovering/hover taxiing between ramp area and taxiway. Due to wind/wind gust helicopter drifted into wind sock area and rotor contacted wind sock and wind sock mast. See attached pilot narrative.Accident 20090731048899ACessna 182A · Watertown, SDThe pilot stated he was 3.25 hours into a 5 hour flight when the engine quit. He landed in a field 13 se of Watertown, SD. The aircraft received substatntial damage to the belly, firewall, prop, and landing grear. The pilot and 2 passengers were not injured.…Incident 20090731048609IMaule MX-7-160 · Worthington, MNUpon initiating a landing at Worthington airport, aircraft experienced windgusts, propoised, spun around and the left main gear partially collasped. The left wing tip and propeller struck the runway. No injuries to pilot or passenger. Some pilot and aircraft…Incident 20090731047939ICessna 525A · Bridgeport, CTOvershot runway, wet runway conditions, modulation of brake pedals.Incident 20090731019899IBeech 95B55 · Columbus, INOn July 31, 2009 while on an operational check flight after maintenance was performed on the right engine (spark plugs and wires) the pilot experienced a catastrophic engine failure of the left engine. The pilot feathered the left propeller and shut down the…Accident 20090731018579AHawker F90 · Tucson, AZPilot reported a bird strike (thought it was hawk). He did not declare an emergency, landed without incident.Accident 20090731017699ACessna 337F · Frankfort, MIPilot found oil leak at base of rear engine oil filter upon landing at Frankfort airport. Pilot elected to feather rear engine and attempted single engine takeoff. Pilot flight times and flight review date are as reported by pilot, pilot stated logbooks were…Accident 20090731017609ACessna 177RG · Black River Fa, WIOn July 31, 2009, at 10:54 CDT, the pilot of a Cessna 177RG struck a house while attempting an emergency landing at the Black River Falls WI. The aircraft engine lost power due to broken #2 cylinder piston connecting rod. The pleasure flight was conducted in…Accident 20090731016799AAmtr RANSS6S · Montezuma, INTakeoff roll was initiated at the north end of a 600' mowed grass area, north of and attached to 9IN6, with one passenger. Temperature was approximately 80 deg f and slight westerly wind. N19226 lifted off the ground within the first 300' of the 600' of grass…Accident 20090731015839AAirtrc AT502B · Minter City, MS(-23) On take off, aircraft became airborne, began turning, and did not have enough altitude to clear the pecan orchard. Aircraft crashed into 3 pecan trees. Aircraft sustained subtantial damage. Pilot sustained serious injuries and was air lifted to elvis…Accident 20090731015162ACessna 182J · Iowa Falls, IA(-23) The pilot departed belmind airport (Y48) and was enroute to Iowa Falls airport (ifa). He was in range for landing and about eleven miles out; stated he began transmitting his intensions on UNICOM 122.8. Witness statements support the facts as presented…Accident 20090731015019AAmtr RV6A · Deming, NM(-23) On July 31, 2009, at 1045MDT, a vans RV6-A, N613LE, registered to the owner, was unable to reach the runway after initiating a "go around" due to glider activity on the runway at Deming, NM airport while on a part 91 flight. A NOTAM #7/017 was filed at…Accident 20090731014899ACessna 182K · Conway, AR(-23) On July 31, 2009, at 1630 CDT, a Cessna 182K, N521SP registerd to department of Arkansas state police, landed hard at Arkavalley airpark, greenbrier, Arkansas, while on a public use flight. Visual meteorological conditions prevailed at the time and no…Accident 20090731014811AMooney M20C · Iowa Falls, IA(-23) The pilot departed eldora airport (6C0) and traveled to Iowa Falls airport (ifa). He stated he was transmitting on UNICOM 122.8; however none of the witness statments could support this. He was on left hand approach to Iowa Falls airport, and on short…Accident 20090731013219ABeech 400A · Houston, TX(-23) On takeoff roll approximately 2000 ft down the runway pilots observed three birds (1 large 2 small) flying across the flight path from left to right. At least one bird made contact and immediately the right engine rolled back and the aircraft yawed to…Incident 20090731013069IBeech 65A90 · Shell Knob, MO(-23) Pilot lost directional control during lanidng roll on wet grass and struck a drainage ditch, collapsing the left main gear leg.Incident 20090731013059IScwzer G164B · Ne Marshall Co, IA(-23) Mr. Watts, the pilot, was flying parallel to a line of electric wires traveling east to west. His attention to the right wing distance from the poles distracted him from the cross country lines ahead. He hit the bottom wires with the propellor, cutting…Incident 20090731012989IEclips EA500 · Omaha, NE(-23) During the landing rollout on rwy 12, the right brake locked and the tire began to skid. The aircraft continued forward motion and exited the left side of the runway knocking down one runway light. The pilot was able to get the aircraft back on the…Incident 20090731011889IEMB EMB120 · Salt Lake City, UT(-23) Skywest flight 7780 departed slc. On climb out they struck a large bird. The crew elected to return to slc for maintenance to look at the aircraft.Accident 20090730048549AP&M Aviatio Quik GT450 · Oshkosh, WIAircraft bounced after hard landing then hit hard again and broke nose gear which caused aircraft to roll over on its side and break apart.Incident 20090730048539IPiper PA-18 · Brainerd, MNPilot took off on runway 5 at Brainerd MN, made left turn. Just after leveling off the engine RPM started to drop. As RPM kept dropping pilot found a place to land on the river, in a wild rice paddy. Because aircraft had tundra tires it came to a complete…Accident 20090730048459ACessna 172N · Manassas, VAOn July 30, 2009 a student pilot operating a Cessna 172N, r/n: N733BS made a normal departure from Manassas regional airport (khef). Upon returning to (khef) he was cleared to land on rwy 34L. He made a normal landing and exited rwy 34L at taxiway A3. He…Incident 20090730048089IPiper PA-31-350 · Kotzebue, AKPilot stated the aircraft was not operated for some time and that he wanted to inspect the gear doors as part of his preflight. The pilot stated he inadvertantly selected the gear handle to the up position then pumped the emergency gear handle to extend the…Incident 20090730048059IPiper PA-25 · Sterling, MAPilot landed at Sterling airport, aircraft nosed over on landing rollout.Accident 20090730048049ACirrus Desi SR22 · Ravenswood, WVRavenswood Airport, WV (I18): N581DS, an SR22, departed york, NE (jyr) enroute to eagle creek, in (eye), crashed for reasons unknown in a rural area 9.6 miles from Ravenswood Airport, WV (I18). The local authorities responded and reported no injuries or…Accident 20090730048009AChristopher CHR-1 · Norridgewock, MEOn approach to central Maine airport, norridgewok, ME the pilot heard a loud bang and immediately experienced a vibration accompanied by significant power loss. Two witnesses on the ground stated that the aircraft was running loudly and emitting black smoke.…Incident 20090730047989IPiper PA-34-220T · Ronkonkoma, NYPilot reported unsafe nose gear indication prior to landing. After four attempts to lower landing gear performed low pass at kisp tower, personnel indicated nose gear did appear down, but not fully extended. Pilot landed runway 24, nose gear collasped on…Incident 20090730015769IAmtr LANCAIR4P · Truckee, CA(-23) The aircraft landed in a construction area, short of the displaced threshold, on runway 28, striking several temporary construction barriers. The composite propeller was shattered and the nose wheel assembly broke away from the strut assembly.Accident 20090730014669ABeech 76 · Glendale, AZ(-23) On 7/30/2009 at 1510 MST, after performing a normal landing the pilot and student taxied off runway 21 at taxiway A6. The gear warning horn sounded, and immediately thereafter the left main gear collapsed. Investigation revealed the left main gears…Accident 20090730013149APiper PA28151 · Purcell, OK(-23) Airman was flying at a low level down the canadian river when the landing gear impacted with power lines running east to west. The landing gear was broken off the aircraft and the aircraft impacted into the river and was destroyed.Incident 20090730012629ISnias AS350B · Topeka, KS(-23) Enroute from lawrence, KS lwc to fort riley, KS to pick up a patient the aircraft engine oil pressure dropped to zero. A precautionary landing was made in a field approximately 8 miles west of Topeka, KS and 200 yard north of interstate highway 70. 1…Accident 20090729048559ACessna A185F · River Falls, WIPilot fueled up at osh kosh WI. And headed for fleming field st. paul MN. Aircraft engine started sputtering and losing power over River Falls WI.engine completely stopped and pilot put aircraft down in empty lot near corn field. Sheriff was there within 10…Incident 20090729048399ICorso Phili AEROCOMP-7 · Ft. Mc Coy, FLPilot was flying from fpr to lcq at 10,500 and had reduced power to descend to 8500 ft. when leveling off the pilot noticed the power was deteriorating, did not respond to power lever inputs and continued to deteriorate to zero . Attempts at restart were…Accident 20090729047999ACessna 180 · Candle, AKThe pilot stated that the right brake failed and he was unable to maintain directional control during roll out. Aircraft ground looped and received substantial damage; no injuries. Ptrs#AL01200902840Incident 20090729047829IBeech A36 · Hartford, CTThe aircraft experienced a charging system failure during cruise flight in IFR conditions. The pilot was vectored to khfd by ATC while the aircraft battery was discharging. The pilot broke out under the cloud layer at 1500 feet and saw hfd airport. By this…Incident 20090729018629IBoykin Rotorwayexec · Camarillo, CAOn July 31, 2009 at 1000 I met with [privacy data omitted] pilot for helicopter N6992, rotorway exex 162F at his hanger located at Camarillo Airport. I first took pictures of the helicopter, focusing on the tail rotor area that's where most of the damage to…Accident 20090729014579AScwzer SGS232 · Heber, UT(-23) After a 30 minute flight the pilot landed on runway 21 at the Heber airport. He turned off the runway at intersection A2. His speed was high and he could not stop before making contract with a hangar that was directly opposite the A2 intersection. He…Incident 20090729014569ICessna 172M · Venus, TX(-23) The Cessna 172 (N73357) lost power during an instrument training flight. The flight instructor made an off field landing in a large grain field. There was no damage to the aircraft. Location: maverick VOR (ttt)185R, 24.7 DME.Accident 20090729014389AAirtrc AT301(-23) Aerial application southeast of dos palos, CA on 07/29/2009 at 04:15. The pilot landed in an alfalfa field and hit a soft soil water ditch, causing the aircraft to flip end over end. The pilot reported that the engine failed and that he had received…