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 20091014050319IBeech 200 · Lynchburg, VA10/14/09: @16:08 EDT, N174WB, BE-20, lyh, aircraft landed on runway 4 after reporting a shattered windshield. The ARFF responded and the aircraft taxied to the ramp without incident.Accident 20091014025909ACessna A185E · Healy, AKThe pilot stated that there were no mechanical problems with the airplane. He stated that 3 hours into a flight that was tracking wolves, they picked up a signal from a wolf. He made a sharp turn to circle the wolf, at this point he caught a tail wind down…Accident 20091014019979ARobsin R22BETA · Tahlequah, OKPilot, operating a Robinson R22 helicopter, took off from private residence appox 1 mile southwest of Tahlequah airport (tqh) heading to said airport at approx. 0400(l) time on 10/14/09. Aircraft wreckage was found at approx 0840 on 10/16/09 approx. 1 mile…Accident 20091014019949ACessna T210L · Albuquerque, NMOn October 14, 2009 at 15:50 MST, a Cessna CE-210L, N211LC registered to steven suddarth declared an emergency and landed at Albuquerque international airport (abq) with only the nose landing gear down and locked following a landing gear retraction failure…Incident 20091014019589IDiamon DA40 · The Dalles, ORThe student pilot was on his first solo following 2 practice takeoff and landings with CFI, brett zefting, 3164534CFI, shortly after noon. The student's plan and instructions were to depart rwy 30, stay in a left pattern at pattern altitude and land rwy 30.…Incident 20091013052189IBombardier CL-600-2B19 · Wichita Falls, TX1 - The crew was operating as pinnacle flight 4338 and had been given a clearance to descend to flight level 280. As they approached flight level 280 they were issued oposite direction trffic, eagle flight 2736, that was climbing to flight level 270.…Incident 20091013051109IBeech F90 · West Chicago, ILDuring landing after an ILS approach, the aircraft departed the end of a 7500 foot runway and continued 260 feet onto the grass overun.Accident 20091013022149APiper PA28140 · Meadville, PAMr. Hohn thomas bouley, FAA private pilot certificate #2713560, was operating a Piper PA-24-140 aircraft on an IFR flight plan from ellington, CT &7B9) to Meadville, PA (gkj). The IFR flight plan was filed for 5 hours enroute with an IAS of 90 KTS. The pilot…Accident 20091013020229ACessna 182 · Billings, MTOn October 13, 2009 at 1141 mountain standard time (MST), a Cessna 182, N6202A, registered to [privacy data omitted], collided with terrain approximately 25 miles southeast of Billings, Montana, while operating under the provisions of title 14 of the code of…Incident 20091012050259ICessna 210A · Indian Head, MDPilot landed the aircraft with the landing gear in the retracted position.Incident 20091012024169ICessna 208 · Mokuleia, HIOn October 12, 2009, at approximately 1230 HST, a 27-year-OLD male parachutist was fattally injured in the vicinity of Dillingham Airfield in Mokuleia, HI. Witnesses stated that the parachutist departed a Cessna 208 aircraft from approximately 12,000 feet…Accident 20091012023159ADoug 600N · San Diego/El C, CAA U.S. Customs and border patrol helicopter experienced a hard landing during practice autorotation at Gillespie Field, el cajon, CA. This public use accident is being investigated by the NTSB.Incident 20091012021409IAmtr SH2R · Torrance, CAOn October 12, 2009, experimental amateur built aircraft, giardino SH2R, N66MG, landed at Torrance airport with the landng gear up. Interview of the pilot indicates that during approach, toa ATC directed him to change his landing runway to 11R. He thought he…Accident 20091012019499AHughes 369FF · Fossil, ORWhile pulling powerline leader rope (sock line) from one pole to another power pole, aircraft struck top of pole with main rotor blades. Witness saw helicopter slowly sink onto the pole with slight counterclockwise yaw then saw helicopter main rotors strike…Accident 20091012019469ACessna 182F · Elko, NVPilot stated that he attempted a takeoff on runway 23 at Elko, Nevada, when the winds were 160 at 15 knots gusting to 25 knots. After accelerating to just above 50 knots he experienced a wind gust which caused him to lose control of the aircraft. As the…Incident 20091011054139ICanadair CL-600-2B19 · Greer, SCFlight # ASH7166 was on a takeoff roll at gsp and aborted takeoff. Left and right nose tires had tread separation and pieces missing from tires. Aircraft taxied safely to the gate. Caused damage to one aft nose gear door. Both tires were replaced at gsp,…Accident 20091011050329ALuscombe 8E · Weeping Water, NEThe pilot of N1536B accomplished a preflight and fueled his recently purchased Luscombe 8E for a 35 minute flight in daylight visual meteorological conditions. After departing the airport to the south, it appears that the engine was not producing full power.…Incident 20091011050219IDiamond Air DA 40 · Morristown, NJStudent pilot was practicing takeoffs and landings and during the landing touched down hard allowing nose of aircraft to contact runway before the main wheels, resulting in damage to the airplane. Aircraft nose gear collapsed and propeller struck the runway…Incident 20091011050169ICharles D. Skystar KIT · Calhoun, GADuring cruise flight pilot heard noise from the engine followed by immediate engine stoppage. Pilot made off airport landing in a field with no damage and no injury.Incident 20091011025949ISchweizer 269C-1 · Apopka, FLThe pilot in command/flight instructor was conducting helicopter refresher training for the second pilot at orlando/Apopka airport. The second pilot was the "pilot flying." During a practice autorotation from altitude, the second pilot got too low prior to…Accident 20091011022499ALet L13BLANIK · Llano, CAStudent had 5 dual flights on day of the accident. On first supervised solo flight, student stated that the aerotow was normal and at 2,000 feet AGL, he releassed from tow to fly the pattern. Student noticed that he was high for the entry point for the…Incident 20091011020319ISupac LCA · Sacramento, CAPilot failed to lower landing gear from landing, made gear up landing.Accident 20091010054089ATaylorcraft BC12-D1 · Skokomish, WAOn October 10, 2009, about 1300 pacific daylight time, a Taylorcraft BC12-D1, N44362, departed harvey field, snohomish, Washington, for an undetermined location. When the sport pilot failed to return that evening, he was reported overdue/missing. The…Incident 20091010054069IBell OH-58A · Ocala, FLUnexplained power loss during final approach to helicopter landing spot caused public use helicopter to settle and land hard, with minor damage.Accident 20091010050839APiper PA28-151 · Claypool Hill, VAClaypool Hill, VA: N43620, a Piper PA-28-151, departed cincinnati, oh (luk) enroute VFR to mocksville, NC (8A7), crashed in a mountainous wooded area due to loss of visibility 14.3 miles sw from tazewell county airport, VA (jfz). The local authorities…Accident 20091010050789ABeech E35 · Mount Morris, NYFirst time pilot tried to take off down wind from runway 04 on a 1200 feet grass strip. Second time pilot again tried to takeoff from a hay field down wind and the airplane crashed. Pilot last medical was issued in 1998 another was never issued.Incident 20091010050419ICirrus Desi SR20 · St. Augustine, FLDuring landing, student pilot allowed aircraft to porpoise multiple times. Post flight inspection revealed nose gear assembly damage.Accident 20091010050299APiper PA-31-350 · Nondalton, AKThe aircraft developed a high sink rate while on approach to the Nondalton airport. Pilot added full power which was not sufficient to effect a sucessful go-around.Accident 20091010023169ATecnam P2004BRAVO · Elk Grove, CAThe sport light was practicing takeoffs and landings at franklin field, CA. The aircraft had made multiple prior to the occurance on one of the takeoffs the engine failed. The aircraft flipped over during the emergency landing.Accident 20091010022209ACessna 172M · Tucson, AZMr. Matthew henkel was performing touch and go landings. The power was at idle and the flaps were set to 30 degrees. During one of the landings he stated the aircraft veered left. He allowed the aircraft to continue to the left making very small corrections.…Accident 20091010021441ACessna 150F · Pineville, LAThis aircraft (hereafter referred to as the lead aircraft) is one of two aircraft involved in a mid-air collision. The two were performing a formation flight, "low fly-by" of the runway at the Pineville, Louisiana airport during an eaa fly in. Upon a right…Accident 20091010021432ACessna 150F · Pineville, LAThis aircraft (hereafter referred to as the second aircraft) is one of two aircraft involved in a mid-air collision. The two were performing a formation flight, "low fly-by" of the runway at the Pineville, Louisiana airport during an eaa fly in. Upon a right…Incident 20091010020369ILear 35A · Pittsburgh, PAOn October 10, 2009, at approximately 0035 eastern time, a gates Learjet 35A, operated by medway air ambulance incorporated (Y6WA) under 14 CFR part 135, flew from the Washington dulles international airport (kiad) to the Allegheny County Airport (kagc) and…Accident 20091010019559ACessna 180A · Condon, ORPilot departed from home airport, ashland, OR (S03) at 8:30 with 1 passenger onboard. He arrived about 10:30 at his destination of an un-improved landing strip on the john day river called chucker flats. Wind was 5 to 7 knots on a clear day. Approach was from…Accident 20091010019389ACessna 180 · Cascade, IDPilot stated that on landing rollout at slow speed. He ncountered a microburst which caused him to lose control of the aircraft resulting in substantial damage to the landing gear and wing spar.Accident 20091009054049AMooney M20C · Marathon, FLUpon final approach aircraft went down 2 miles off the coast of Marathon, FL. Pilot stated loss of power. Aircraft was never recovered or found.Accident 20091009050689APiper PA-18-150 · Bingham, NEThe PIC was on a VFR flight in VMC conditions. He reported that he must have dozed off. The aircraft then impacted a farm pond at a low angle and skidded to the waters edge. The pilot sustained a broken jaw and minor cuts and the aircraft was destroyed. A…Incident 20091009050439ICessna 177RG · Rochester, MNAircraft nose gear collapsed during laniding rollout.Incident 20091009050199ICessna 750 · Newport News, VAOn 10/09/2009 at 2327Z, N9NG, a CE-750 returned to phf and landed on runway 25 after reporting low oil pressure. ARFF responded and aircraft taxied to the ga ramp area without incident.Incident 20091009022809ICirrus SR22 · Mountain View, CAAt approximately 2,500 feet MSL about 6 miles from moffet Federal airfield airplane shook noticeably and the power dropped. Pilot stated he contacted moffet tower to request an emergency landing. During the telephone interview pilot stated he retarded the…Accident 20091009021709AAmtr SE5A · Phoenix, AZPilot took off from dvt airport from runway 25. Upon reaching the end of the runway the dvt tower cleared the pilot to turn to the north. The pilot initial reply was garbled and the tower repeated the instructions. The pilot then responded to the instructions…Incident 20091009020421IArostr RXS8 · Albuquerque, NMAt 0830 MDT on October 9, 2009 during competition at the Albuquerque international balloon fiesta, N5012U, and Aerostar RXS-8 hot air balloon, collided in flight with N3021P, a lindstrand 90A hot air balloon, causing minor damage to N3021P. The collision…Incident 20091009020322ILBL 90ALBL · Albuquerque, NMAt 0830 MDT on October 9, 2009 during competition at the Albuquerque international balloon fiesta, N5012U, and Aerostar RXS-8 hot air balloon, collided in flight with N3021P, a lindstrand 90A hot air balloon, causing minor damage to N3021P. The collision…Accident 20091009020019AAmtr Pittsspecial · Alamosa, COOn October 9, 2009 at approximately 1010 mountain daylight time, a single engine pitts special S-1, N59JT was substantially damaged when it hit a runway light and the propeller hit the ground. The pilot was practicing a full control stick forward procedure…Incident 20091008050349ICessna 750 · Wichita, KSOn the evening of October 8, 2009 at 2332 z, N90NF, a Cessna citation 750, landed at mid Continent airport, Wichita KS (ict) with a failure of the nose gear retract mechanism which prevented the nose landing gear from extending. The right nose gear door…Accident 20091008050189ASchweizer 269C-1 · Lewiston, MEOn October 08, 2009 at approximatley 0845 eastern daylight time a Schweizer 269-C, N1835 piloted by a certificated pilot sustained substanial damage during a collision with the ground. The pilot and passenger were taxiing out to the runway 35 area when the…Accident 20091008050129ARemos Aircr Remos G-3/6 · Wilson, NCPilot stated the sun was in his eyes, and he looked down to reach for his cap in the seat. Next thing he knew he hit the lake.Incident 20091008023229ICessna 550 · San Diego, CAPilot was conducting pre-dawn takeoff on rwy 18 at nzy. Weather was VMC. Runway c/l lights were set to low intensity. Ambient light level was low. SIC was focused inside aircraft conducting pre-takeoff checks as pilot taxied onto rwy 18. Pilot taxied aircraft…Incident 20091008020359IPiper J3F65 · Santa Ana, CAThis was a local flight departing from and returning to John Wayne airport (sna). The pilot was attempting his first landing to a full stop on runway 19L. During the landing the right wing began to fall and the aircraft began to move right and the pilot…Incident 20091008020079ICessna 210N · Lubbock, TXOn October 8, 2009, at approximately 1240 CDT, N9963Y, a Cessna 210 aircraft, ran out of fuel approximately 15 nautical miles northwest of Lubbock preston smith international airport (lbb), in Lubbock, Texas, and subsequently made an emergency off airport…