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 20120711011989ACirrus Design SR20 · Moscow, TNOn July 11, 2012, at approximately 0850 CDT, N764RV, a Cirrus SR20, registered to Mr. Rick vaughn, crashed near Moscow, TN. The pilot was fatally injured. There were no passengers and no fatalities on the ground. The 14 CFR 91 flight departed knqa at…Incident 20120710018659IPiper PA-34-220T · Rome, NYPilot departed rochester, NY (roc) for Rome, NY at approximately 0700 LCL time. The part 91 flight was made in VFR conditions. Wx at the destination was VFR with calm winds. While attempting a landing on runway 15, the pilot stated that he realized his…Incident 20120710016719ICessna T210M · Corona, CA[privacy data omitted] Did not lower landing gear prior to landingAccident 20120710016249ACessna 172M · South Wayne, WIAircraft was enroute from kokomo, in (okk) to south st. paul, MN (sgs). While in cruise flight at 4,500 ft., the engine seized and the propeller stopped. The pilot made a forced landing in a rolling soy bean field in the vicinity of South Wayne, WI. During…Accident 20120710015529ACessna U206G · Homer, AKThe pilot stated that he and his friends had departed 6 mile lake at elmendorf air force base and flown to kenai, Alaska for dinner. After dinner they departed kenai for beluga lake. The winds were out of the south and he entered a final approach for a south…Accident 20120710014929APiper PA-18-150 · Beluga, AKWhile attempting to take off from a mountain ridge, the airman allowed the left wing to contact the ground after experiencing a strong crosswind gust. This caused substantial damage to the airplane.Accident 20120710014259ACessna T210L · Idaho Falls, IDLanded rwy 02 pilot forgot to put down the landing gear down after going through a thunderstorm 15 minutes previous to landing.Accident 20120710014209ACessna 172S · Grand Forks, NDPilot was landing, flared late causing hard landing causing structural damage to engine firewall. Student pilot certificate:# [privacy data omitted]Accident 20120710014179AMaule M-4 · Springfield, MNDuring the wheel landing, as the pilot was setting the tailwheel down, the aircraft veered right. As a result, the left wintip dragged on the runway and the left main gear collapsed, folding under the fuselage. The aircraft exited the right side of the runway…Accident 20120710014149ABeech 58 · Traverse City, MIPilot stated he forgot to extend gear prior to landingAccident 20120710014049AMchargue Leslie L Buckeye Dream · Central City, NEPilot [privacy data omitted] and passenger [privacy data omitted] attempted take off from a grass strip to the east and failed to gain enough altitude to clear power lines. Pilot throttled back to decrease altitude causing the powered parachute vehicle to…Accident 20120710013779ACessna 177B · Gooding, IDDuring the flare to land on runway 07, the aircraft's left wing violently was pushed upward causing the aircraft to hit the runway hard and vear to the right. The aircraft rolled out into the weeds and hit a small ditch. The pilot added power to get the…Accident 20120710013719ACessna A188B · Cheyenne, WYOn July 10, 2012 at approximately 0710 hrs MDT, N4831R, a Cessna model A188B agwagon aircraft was destroyed after impacting terrain near Cheyenne, WY. The sole occupant on board received serious injuries. Weather at the time was VMC.Accident 20120710012389APiper PA-28-236 · Chester, CTAt approximately 10:57 EDT on July 10, aircraft N777AF, a Piper PA-28-236, s/n 28-7911328, landed long on runway 35 and went off the north end of the runway at approximately 10:57 EDT. There was one person onboard and no injuries were reported. The flight was…Incident 20120710011669ICaldwell John L SKY Raider II · Caldwell, IDThe pilot was performing a maintenance test flight after the annual and the installation of a newly overhauled engine. The pilot performed 15 minutes of taxi testing with no problems noted. The pilot positioned the aircraft on runway 12 for take off and added…Accident 20120709018709ACessna 172S · Allentown, PAStudent lost control of the aircraft during a touch and go on runway 25. Aircraft veered left and hit airport sign. The aircraft continued across the grass and came to rest on a small hill.Incident 20120709018359IPiper PA-28R-200 · Falmouth, MAEnroute to ack, descending through 7,000 feet, the top cowl departed the aircraft and struck the left windscreen causing a large hole in the plexiglass. The CFI at the controls occupying the right seat contacted Cape approach and declared an emergency. The…Accident 20120709014439ARobinson Helicopter R22 Beta · Murrieta, CAMurrieta/temecula, CA: N7527Y, Robinson R22 helicopter, instructor pilot was performing a low level hover demonstation when aircraft rolled onto left side 4 miles east-southeast of french valley airportAccident 20120709014419ABeech A36 · Charleston, SCAt 08:20 am the pilot departed bow enroute to jzi. Aav approach notified the pilot to recycle the transponder and he was handed off to beaufort approach who notified him that his transponder was not working. The pilot scanned the instrument panel and noticed…Accident 20120709014379AMooney M20L · Scottsdale, AZOn July 9, 2012 at approximately 0929 MST, aircraft N137MP, a Mooney M20L serial number 26-0017, was performing touch and go's on runway 21 at the Scottsdale Airpark (sdl) in Scottsdale, AZ when the pilot lost control of the aircraft and it crashed to the…Incident 20120709012449ICirrus Design SR22 · Hillsboro, ORAfter a bounced landing on runway 31 at khio, the pilot in command attempted a rejected landing of his Cirrus SR22. The result was that the airplane drifted over the infield, impacted the ground, and sheared off its left and right main landing gear. The…Accident 20120709012379ABell 47G-3B-2 · Treynor, IAAs stated by the pilot, during aerial application while traveling north the aircraft momentarily torqued left and a warning light quickly flashed. A check of the gauges was performed and all appeared to be normal, including fuel quanity which was just below…Incident 20120709011749IPiper PA-28-181 · Marlboro, MAOn landing runway 32 at 9B1 ran off the end of the runway and into a fenceAccident 20120708015979ABellanca 7GCAA · Bedford, INOn July 8, 2012 at 1303 EST, aircraft N8733V (a Bellanca model 7GCAA serial number 316-75 [privacy data omitted]) on a personal flight to salem municipal airport in salem, Indiana (I83) crashed in a field approximately 1 mile from the approach end of runway…Accident 20120708015799APiper PA-42 · Beckley, WVCharleston airport, WV (crw): N332SM, a PA-42 cheyenne iii, lost gyros after encountering undetected severe convective acivity and returned and landed on runway 5. Prior to landing the aircraft was observed climbing out of 18,000 feet and within a minute…Incident 20120708014959IRaytheon 390 · Ada, OKAircraft performed high speed abort. Then subsequently returned to the runway to perform another takeoff. Time between takeoff attempts was less than 6 min captured by airport video. Tire damage was extensive and resulted in one main tire departing the hub on…Incident 20120708014839IPiper PA-18-150 · Palmer, AKThe pilot in commands written narrative stated: he was conducting an Off Airport training exercise. During the landing phase to a river gravel bar, his aircraft encountered gusty wind conditions that caused the aircraft to rise smoothly to about 10 feet above…Accident 20120708014769APiper PA-32R-300 · New Site, MSOn July 8, 2012, approximately 1400 hours CST N4386F was substantially damaged when it impacted the trees, ground and came to rest in a heavily wooded area. The pilot and 2 passengers were fatally injured. The pilot and 1 passenger were in the main wreckage,…Incident 20120708014219ICessna LC41-550FG · Alma, MIPIC lined up with and landed on taxiway parallel to runway.Incident 20120708014169IBombardier CL-600-2C10 · Minneapolis, MNOn a reposition flight to msp, the first officer began to pull back on the control column for the landing flare and found it to be jammed. He advised the captain and both pilots then attempted to pull back on the control column. The captain reported hearing a…Accident 20120708013739ACessna 190 · Anthony, TXOn July 8, 2012 at 18:20 MDT a Cessna 190, N190W registered to perlan aviation, LLC, departed the runway and ground looped on landing at Cielo Dorado Estates Airport (TA50) near Anthony, Texas while on a personal flight. Visual meterlogical conditions…Incident 20120708013399ICessna 182Q · Block Island, RIAfter landing at kbid and enroute to a grass parking space with a follow me vehicle leading, aircraft propeller hit a taxi light. One prop blade was damaged. No other damage or injuries.Incident 20120708011969IBeech F33C · Eagle Lake, TXThe pilot stated he forgot to lower the landing gear. Aircraft landed with the landing gear in the up position. No injuries, minor damage to aircraft.Accident 20120707018559AJones Peter M Boeing/Jones 75 (B75) · Bayport, NYPilot started takeoff roll to the south, windsock was showing southwest wind. After rotation, aircraft was not climbing. Pilot decided to abort takeoff and put aircraft back on the ground. Upon touching down on the ground the pilot used hard braking to avoid…Incident 20120707015159ICessna 182E · Reedsville, PAParachutist christopher brown jumped from a Cessna 182 jump plane operated by Pennsylvania skydiving university corp. a ground witness reported that his chute was at least partially open, but that he was descending at an excessive rate. Mr. Brown was killed…Accident 20120707014819AMurray Richard F Aircam BY Lockwood · Taos, NMWitness statements indicate pilot was flying between 50 and 100 feet AGL near the rio grand gorge rim when the aircraft abruptly pitched up then rolled and impacted the ground vertically. Rio grand gorge runs n/s and is from 900 to 1000 feet deep at the…Accident 20120707014199AGrumman G-164A · Egeland, NDPIC had just completed spray pass and was turning to set up for next pass and aircraft lost power. PIC says no mechanical indication/noise, just no power and aircraft kept losing altitude and contact wheat crop, dragging into the field/ground.Accident 20120707013709ABeech E-90 · Karnack, TXAircraft was receiving VFR flight following from ZFW30 to brownsville TX. Aircraft entered an area of thunderstorms at altitude 14600. Pilot call stated trying to exit the area. Radar and radio contact were lost simultaniously.Accident 20120707013479AShorey Timothy A Preceptor Stol King · Fairbanks, AK7/7/2012AIRCRAFT was on landing approach and engine lost power. Aircraft hit powerlines and crashed to ground. Reduction drive belt came partially off pulley causing power loss.Accident 20120707013359ADehavilland DHC-2 · Cantwell, AKWhile flying at 1000 to 1500 feet the aircraft engine suddenly flamed out. The pilot was unable to restart the aircraft and made an emergency landing. Aircraft remained upright and slid to a stop. After landing, the emergency fuel shutoff lever was found to…Accident 20120706028429ACessna 207A · Kotlik, AKThe pilot impacted a river while adjusting power settings after departure from Kotlik. He returned to Kotlik and on landing the propeller and nose struck the ground. He had lost the nose gear at the landis fork during the impact with the river.Accident 20120706018669APiel CP-305 Emeraude · Boone, NCThe aircraft was on a flight from kmrh to the blue ridge mountains and back. The aircraft refueled at ashe co.(kgev) the aircraft continued to johnson co.(6A4), the aircraft was topped off with fuel. The aircraft proposed route of flight was to over-fly elk…Incident 20120706015709IBoeing B75N1 · Springfield, MOWhile providing instruction to the aircraft owner, during the landing rollout on rwy 20 at the Springfield - Branson National airport (sgf) in Springfield, MO., the aircraft drifted to the right of centerline. The CFI took the controls and applied left brake,…Accident 20120706015029APiper PA 46-350P · Auburn, ALOn July 6, 2012, [privacy data omitted](pilot) was landing at Auburn, Alabama (kauo). The landing was executed with normal procedures until the nose wheel touched down on the runway. The nose gear then folded back into the wheel well causing the aircraft…Incident 20120706014369IElliotts Of Newbury Olympia II · Elmira, NYPilot elected to stretch downwind leg and land behind another glider. Pilot stated on turning on the short base, airspeed was 5O KTS and satisfactory. Final approach seemed satisfactory but when he rounded out to land, the glider stalled. Pilot stated he…Accident 20120706014119AGrumman American Avn. AA-5A · Ray, MIUpon touchdown for landing on runway 9 at 57D the aircraft bounced 2 to 3' into the air and the pilot saw 2 deer jump up off the left side of the runway. One deer ran into the path of the aircraft striking the left wing leading edge inboard of the wingtip.…Accident 20120706013499APiper PA-12 · Quinhagak, AKAbout five miles east of Quinhagak, AK, the airman was acting as pilot in command of a PA-12 when he lost control after a balked landing which resulted in a crash and substantial damage to the aircraft. No injuries were sustained by the PIC nor by the…Accident 20120706013469ABellanca 7GCBC · Fairbanks, AKUpon landing at Clear Creek the pilot raised the tail to practice operating the aircraft on two wheels in an off-airport situation. The engine was at very low RPM, pilot reported about 900 RPM. When he pulled back on the stick to put the tail down, he also…Accident 20120706013389APiper PA-18-150 · Skwentna, AKThe PIC overflew a gravel bar on the talchulitna river with the intent on landing to fish. The bar looked good and he landed. On his roll out he ventured too FAR to the grassy side of the bar when the left gear dropped into a hole hidden in the grass causing…Accident 20120706012439ABellanca 17-30 · Hillsboro, ORAfter N7322V touched down on the centerline of runway 31 at Portland Hillsboro airport, it immediately departed the left border of the runway into the adjacent grass infield. The aircraft came to a stop after impacting a PAPI light display.