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 20100306031039ANorth Ameri SNJ-6 · Santa Rosa Beac, ALOn March 6, 2010 at 1235 local, N47LF attempted to perform an aerobatic rolling maneuver to the left at approximately 500 feet MSL. The pilot lost control of the aircraft and crashed into the gulf of MexicoAccident 20100306030109ALuscombe 8A · Savannah, GAA written statement provided by a witness mentioned that he provided a prop off to the PIC. After takeoff, pilot was not seen again. Local law inforcement reported later that aircraft was found in a pond. Pilot did not survive crash. Unable to determine cause…Incident 20100306029439IPiper PA-24-180 · Sterling, PAPilot landed at 70N and did not realize that snow had drifted on the FAR end of the runway, narrowing the runway. The wing struck the snow causing the aircraft to spin into the snow bank near the end of the rool out.Accident 20100306029299ADiamond Air DA 20-C1 · Mt Sterling, KYOn 03-06-2010 at approx 3:00 p.m., N365DC,a Diamond DA-20-C1, was being flown solo by a student pilot in the FAR part 141 flight program for eastern KY univ. According to the student pilot, she was on her first solo cross-country from richmond - Mt Sterling -…Incident 20100306029249ICessna 152 · Quakertown, PAStudent pilot was landing runway 11 student stated that he landed left of centerline and aircraft drifted into a snowbank, upon striking the snowbank the aircraft flipped onto its roof.Accident 20100306029109ACessna 172P · Camarillo, CAOn the takeoff phase of a touch-and-go on runway 08 at Camarillo Airport, [privacy data omitted] lost control of the airplane, which veered off of the left side of the runway, flipped over, and landed inverted north of runway 8, abeam of taxiway 'c'.Accident 20100306029019APiper PA-28-140 · Martinsville, INAircraft was loaded 131 pounds over maximum gross weight and the pilot attempted to take-off from a 2000 foot grass runway. Aircraft was unable to climb after rotation, thus the pilot elected to land in a field just off the departure end of runway 27 of the…Incident 20100306028809IBellanca 7GCBC · Monroe, NCThe pilot([privacy data omitted]) stated as he was landing at Monroe airport (eqy)the aircraft verred to the left and aircraft nose hit the ground.Accident 20100306028799ARaytheon Ai A36 · Milwaukee, WIOn March 6, 2010 at 1411 local time, a Beechcraft A-36, N1114X operated by [privacy data omitted], commercial pilot certificate [privacy data omitted], was performing a touch and go at Timmerman airport, Milwaukee, Wisconsin runway 22R. While accelerating for…Incident 20100306028739IPiper PA-28-180 · Urbana, OHAircraft N8802J touched down in the high snow approximately 30 feet short of runway 2 at Grimes Field (I74). The aircraft came to rest on runway 2. The damage consisted of the nose wheel assembly being bent rearward, minor right wing damage, right and left…Incident 20100306028629ICessna T210L · Jenks, OKOn the afternoon of March 6, 2010 private pilot and an instructor pilot, departed krvs on an IFR flight plan. The weather was clear with a south wind. The purpose of the flight was pleasure and practice. After shooting 2 GPS approaches at mko, one to a full…Accident 20100306028609ABelcher Wil Firestar · West Blocton, ALAfter take-off from Cunningham field (private) pilot experenced loss of directional control caused by a broken tail wheel stinger tube and lower rudder hinge, pilot attempted an emergency landing, but landed in trees parallel to runway. Aircraft recieved…Incident 20100306028599ICessna 525B · Seattle, WAShortly after rotation, gear up we heard a series of 3-5 loud bangs. The aircraft yawed sharpley to the right and the engine would surge, we noted the RH engine itt was indicating full scale and flashing red. The control tower notified us that fire and rescue…Incident 20100306028519IAviat Aircr A-1B · Belle Vernon, PAPilot reported that while attempting to practice slow and low level flight along the snow covered area adjacent to active runway 26, the aircraft tail wheel became entrapped in the snow; impeding further forward flight. Aircraft N25AS was found inverted in 1…Accident 20100306028509ARobinson He R22 Beta · Cotulla, TXOn mar. 6, 2010, a helicopter, N922SH Robinson R-22, was engaged in a predator control flight, on a private ranch northwest of Cotulla, Texas. These hunts are conducted at tree top level. The pilot would take a shooter, passenger, up for 20 minute flights and…Accident 20100306004989AMcdonnell D 369E · Delta Junction, AKDuring cruise flight, engine lost power. Helicopter autorotated into small trees causing substantial damage.Accident 20100306004979AAviat Aircr A-1C-200 · St. Johns, AZAircraft N134DD took off from rwy 21 at ksjn at 1700L on March 6, 2010. The aircraft crashed shortly after take off. The aircraft sustained substantial damage to the wings, nose, props and fuselage. The pilot and one passenger were not injured. There was no…Accident 20100305030599APiper PA-34-200T · Vero Beach, FLOn March 5, 2010, N103GK, a Piper seneca ii (PA-34-200T) crashed in a neighborbood, about one mile south of the Vero Beach municipal airport. An eyewitness stated that the twin engine seneca appeared very low and appeared to be losing altitude. The aircraft…Incident 20100305030219ILear L35 · Woodstock, ONAircraft climbed to FL320 when cleared to maintain FL300.Incident 20100305030149IYakovlev YAK-50 · Camarillo, CAOn 03/05/2010 1200 PST, N50RK was landing runway 8 at Camarillo Airport, Camarillo, CA. Upon roll-out and turning off the active runway, N50RK'S left main landing gear failed resulting in the left wing tip and prop striking the runway surface.Accident 20100305029049AEvektor-Aer Sportstar P · Marysville, OHHistory of flight on 03/05/2010, about 0900 eastern standard time, an experimental light sport Evektor-aerotechnik as super sport, N930LA, crashed in an open field approximately four and a half miles southeast of the Marysville, Ohio union county airport…Incident 20100305029029IPiper PA-32-301 · Key West, FLWeather was clear, reported winds at time of landing, 360/10. On touchdown, pilot lost conterol and exited the runway damaging the right landing gear, nose gear and one of the three propeller blades. 6 occupants including the pilot, no one was injured.Accident 20100305028979ACessna U206G · Nanwalek, AKAirman was approaching to land on runway O1 to the north. Pilot stated that his base leg to final was normal. On final approach, pilot stated the aircraft floated a bit but nothing that worried him, upon touch down he applied the brakes and the a/c slid to…Accident 20100305028969ACessna 172R · Newark, OHThis is a statement regarding an accident involving a student pilot flying a Cessna 172R which occurred at the Newark Heath airport (kvta) at approximately 1500 local time. At approximately 1520 EDT this office received notification that an aircraft had gone…Incident 20100305028779IPiper PA-32-300 · West Chester, PAThe pilot stated he was landing to the west on runway 27. A crosswind was from the right. When the pilot started his flair for touchdown he failed to fully correct for the crosswind and the LH wheel of the aircraft settled into soft snow just off of the left…Accident 20100305028709ACessna 172N · Wappinger Falls, NYOn 3/5/10, N737HV, flown by [privacy data omitted], landed approximately 20' left of the runway, in snow/sod, while attempting to land on runway 06 at pou. Upon ground contact, the aircraft struck its left wing causing substantial damage. In addition, the…Incident 20100305028689ICessna 310Q · Hartsville, SCOn 03-05-2010 a Cessna 310, N5LH, departed titusville, Florida in route to richmond, Virginia. While landing for fuel at Hartsville, SC the right gear did not indicate a green light down and locked. The pilot tried to manually lower the gear, but the gear…Accident 20100305028579ABeech A36 · Lorenzo, TXOn March 5, 2010, at 2152 zulu N2036Y, a BE-36-A36 lost engine power during cruise flight. The pilot of the aircraft declared an emergency and executed an emergency landing. The engine lost power when the aircraft was in level flight at 5500FT eastbound 20…Accident 20100305028559ATarantola L RV-6A · Onalaska, WAUpon landing at private strip nose wheel sank in mud and aircraft flipped over.Accident 20100305028549ACessna P210N · Miami, FLAircraft landed at tmb airport, pilot requested directions to fix base operator (FBO), while taxiing in a non controlled ramp area, collided with an unlit and unmarked helicopter bogey (platform), right landing gear collapsed, nose gear bent, right wing…Incident 20100304042509ICessna 210L · Cumberland Isla, GAEngine failure at approximately 1000 ft off Cumberland island beach. Pilot unable to restart engine and landed gear up on beach. Engine propeller sustained damage.Incident 20100304030299IPiper PA 46-350P · West Chester, PAWhile landing on runway 27 at brandywine airport with a right crosswind the pilot flying the aircraft touched down on the main wheels with crosswind control input. After touchdown the aircraft swerved right and then to the left followed by a swerve to the…Incident 20100304029199IAeronca 7AC · Cottage Grove, MN[privacy data omitted] Was giving flight training to [privacy data omitted]. The instructions was basic ski landing and takeoff techniques in an AERONCA7-AC.during the approach, the flying pilot, [privacy data omitted] applied hard right rudder while…Accident 20100304029009AEnstrom 280FX · Goshen, INDuring the first flight after the annual inspection to perform rotor tracking and balance the engine lost power due to fuel exhaustion. Executed an autorotation into a corn stubble field resulting in a hard landing.Incident 20100304028939IStephen Hac Lightning · Eden Praire, MN[privacy data omitted] Was practicing (solo)touch and go landing in his expermental aircraft. [privacy data omitted] Is training for his private pilot certificate under his CFI, [privacy data omitted]. [privacy data omitted] Had trouble during approaches with…Incident 20100304028849ILearjet 45 · West Palm Beach, FLAfter takeoff during climbout the right bleed air leak fault light illuminated. The PIC responded by viewing the emergency checklist(quick reference guide) for the procedure to be taken and then shut down the right bleed air which in turn caused the light to…Incident 20100304028459ICessna 172RG · Casper, WYPilot actuated gear handle on the ground rollIncident 20100304028449IMcdonnell D 369E · Hilo, HIN500PH, MD500E, because of unspecified mechanical issues made a precautionary landing on the shoreline, 12 miles southeast of the Hilo airport at 1458PST. No reported damage and no injuries.Accident 20100304028419ACessna 152 · Hearne, TXLanded in extreme nose down condition. Upon landing nose wheel colapsed aft and propeller struck the runway.Accident 20100304028389ACessna T303 · Lousia, VAOn 03/04/2010 the pilot, [privacy data omitted], landed his aircraft, N9305T, at the Louisa County/Freeman Field Airport (klku). After landing, the pilot fueled his aircraft with 100LL aviation fuel at the self-serve fuel pump. The mechanic from the airport…Incident 20100303043299IPiper PA-30 · Ashboro, NCWhile at Asheboro airport on March 3rd 2010, at approximately 1645 local time, the pilot stated he decided to take N7790Y to do a full run up and re-fuel it in preparation for a trip on may 4th. Once at the end of the taxiway for runway 03, the pilot started…Accident 20100303034399ACessna P210N · Arcadia, FLOn March 14, 2010, at approximately 1405 eastern standard time, a registered aircraft, N5797K Cessna P210N, serial number P21000324 owned and piloted by a wayne mcdermott, impacted the ground near Arcadia, Florida. The certificated pilot and passenger were…Incident 20100303028869IShort Broth S312 Tucano · Nacogdoches, TXFollowing touchdown and rollout of approximately 1000', on runway 36 at och at 18:45 hours, the nose gear collapsed followed by the main gear collapse at approximately 3000'. The aircraft stayed mainly on the runway surface and came to rest at approximately…Accident 20100303028759AMuffett Pat Quickslvr S · Zillah, WAThe pilot [privacy data omitted] had been working with his instructor and elected to do one last takeoff and landings solo. Albertson stated he ran out of gas just after takeoff and attempted to land of the end of the airport.Incident 20100303028399ICessna T210G · Millington, TNPilot did not use proper technique in recovering from a bounced landing. The aircraft slowed after a bounced landing and entered a high sink rate causing damage to the nose gear, propeller, and nose gear door.Incident 20100303028359ICessna 210J · Lakeway Airpark, TXPilot stated he was doing IFR approaches and was consentrating on the landing and forgot to lower the landing gear. Pilot stated that he did not hear the warning horn, when asked if we put aircraft on jacks to verify, he stated that the horn will work.Accident 20100303028349AMonroig Ped Rans S-6S · Mayaguez, PRMr. Rodriguez departed from the patillas airport (X-64) on N514PM enroute to the Mayaguez airport (maz) aprox. At 12:30PM local time. At the maz airport he made a low pass over runway 9, and proceed to make a left pattern. About 2000 feet down R-09 the…Accident 20100302041649ABeech 65-A90 · Dekalb, ILOn March 02, 2010 Beech 65-A90 N129LA, at Dekalb Airport after normal landing, the left landing gear started to shake then collapsed. Aircraft skidded to a stop. There were no fires or injuries.Accident 20100302030119ASchulke Tom Avid Magnum · Lowell, MILanding on runway 12, aircraft drifted hard to the right after touchdown. Pilot could not arrest drift. Aircraft went off the right side hitting the snowbank along the edge of the runway and flipped over on it's back.Incident 20100302029159ISwanton, OHPilot mistakenly climbed to 11,000 instead of 10,000 as assigned.