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 20040513015339IMooney M20J · Brandon, OR(-23) Pilot failed to extend the landing gear on landing. Pilot is hard of hearing and did not hear the gear horn. Pilot received medical on April 5, 2004.Accident 20040513014479APiper PA22150 · Shelton, WA(-23) Student pilot conducting practice landings in preparation for private checkride. On touchdown the aircraft veered to the left, then hard to the right striking the left wing. Damage to the landing gear and left wing tip and spar. Post accident inspection…Accident 20040513012979AAmtr MUSTANG2 · Wauseon, OH(-23) Owner manufactured reduction gear and clutch assembly failed, resulting in loss of propeller effectiveness. Pilot landed in field short of runway resulting in major damage to the aircraft fuselage, wings, cowling and propeller.Incident 20040513012719IAmtr Searey · Pinecreek, MN(-23) Engine lost power on approach. Conditions and inspection suggest carburetor ice. Transport Canada assisted in the investigation. No structural damage/substantial damage occurred. NTSB notified to change to incident. Aircraft moved to Canada. Transport…Accident 20040513011989APiper PA28180 · Carson City, NV(-23) Witness statement: gary phillips and larry wright both witnessed the accident from the perspective of the ndot hangar parking lot @ close to 0700. The aircraft appeared to be on a low or flat approach, appeared to bounce or start a go-around, drifted…Incident 20040513010369ICessna P210N · Mcminnville, OR(-23) Pilot landed at mmv. During rollout, the nose gear collapsed. Pilot had landed on nose gear which may have caused gear to collapse.Incident 20040513010359IAmtr Kitfoxspeeds · Scottsbluff, NE(-23) The aircraft struck the central runway identifier light with the right main gear while on approach. After rolling out, the right main gear collapsed causing the right wingtip to touch the pavement. Pilot reports there was no "violence" in the landing.…Accident 20040513009959APiper PA28161 · Tucson, AZ(-23) Pilot was taxiing to parking area. The taxiway was adjacent to a large administration building. A back-hoe equipped tractor was operating behind the building and not in view of the pilot. The aircraft was passing the end of the building when the…Accident 20040513009809APiper PA44180 · Wittmann, AZ(-23) On may 13, 2004, at approx 0730 hrs MST, a Piper PA-44-180 aircraft, operating under an instructional part 91 flight, was destroyed during collision with the ground. The three occupants on board sustained fatal injuries. There was no post crash fire.…Accident 20040513009569AAmtr Earlybirdjny · Grantham, NC(-23) N112PE, an amateur built, 2/3 scale early bird jenny, experimental biplane aircraft, departed cox-Grantham airfield (6NC0) at approximately 1830 local. The pilot flew around the area for about forty minutes before attempting a landing on the north…Accident 20040513008509ABell OH58A · Columbia, ME(-23) During cruise flight of approximately 200 AGL pilot reported hearing the tail rotor speed warning beep and immediately started losing power. Pilot initiated an immediate 180 turn back toward the known open field area and attempted autorotation into the…Incident 20040513008189IMooney M20K · Marana, AZ(-23) On may 13, 2004, N1159D made an emergency landing at Marana Arizona causing damage to the under side of the fuselage. Subsequent investigation revealed that the engine had a hole in the crankcase and a broken crankshaft. The aircraft had been flown…Accident 20040512034299ABeech K35 · Lake Worth, FL(-23) While entering downwind for intended landing at palm beach county park (klna) pilot lost power and executed emergency landing in adjacent john prince park, landing on driving range striking nose strut on divot in terrain and flipping aircraft over on…Incident 20040512026699IAmrgen AA1C · Philadelphia, PA(-23) The incident occurred as student pilot was practicing takeoffs and landings on her second supervised solo flight. On landing the aircraft bounced three times which caused a collapse of the nose when struck. Damage occurred to the nose wheel strut along…Accident 20040512021969AKaman K1200 · Glendale, OR(-23) Pilot was logging trees, hit a tree with the main rotor blade.Incident 20040512017539IAyres S2R · Imperial, CA(-23) During cruise flight, the pilot experienced a loss of engine power and had to make an emergency landing into a field. During landing, the left landing gear dug into the soft dirt and was bent under, damaging the adjacent aircraft structure. There were…Accident 20040512011519ARobsin R22BETA · Winsted, MN(-23) On may 12, 2004 gary matthys was PIC of N2301F (Robinson R-22 beta ii helicopter) at approximately 700 feet AGL near Winsted, MN when he heard a loud snap, then smelled burning rubber and the clutch light illuminated. Mr. Mathys assumed he was losing…Incident 20040512008569IAMD FALCON10 · Mesa, AZ(-23) Pilot statement (attached) indicates the flying pilot, Mr. Saiz, executed a normal landing approach for runway 22L (ffz). The pilot stated that the aircraft approach speed was normal and correct VASI indications were displayed. The pilot stated that the…Incident 20040512008429IDhav DHC3 · Juneau, AK(-23) N337AK was in the process of docking (dock hand "grabbed the ropes") with the engine shut down when the dock handler slipped and fell and was not able to secure the aircraft prior to it colliding with the aircraft in front of it, N336AK requiring the…Accident 20040512008119AAviat A1B · Halifax, MA(-23) N17MR crashed while attempting to land on lake. Pilot lost his perception and collided with the water, during a water landing. Pilot became disoriented and lost control at the last second.Incident 20040512007529IGulstm 114B · Boston, MA(-23) N6048B commander cmndr-114-114B s/n 14676 FSDO-01 Wednesday 05/12/2004 [privacy data omitted] N6048B, commander aircraft, comndr-114-114B, departed Boston at 10:54 EDT, 5/12/04 enroute to bridgeport. The aircraft returned and landed runway 04 due to a…Incident 20040511023529ICessna 340A · Brownsville, TX(-23) [privacy data omitted] the pilot went off the runway and one of the propeller blades struck a taxiway light. The pilot reported that the brakes failed.Incident 20040511021939ILkheed 188C · Detroit, MI(-23) Crew was engaged in a part 91 training flight. Crew made a two-engine out (simulated) landing. #3 & 4 main tires blew during roll-out. Aircraft veered to the right and the right main wheels departed edge of ruwnay. Note: the L-188 does not have an…Incident 20040511020039IMooney M20F · Orange, VA(-23) The aircraft was at cruise from morristown, TN (mor) to culpepper, VA (cjr) when the engine quit and the pilot was unable to restart and made an off-field landing hitting the fence and fence posts. The fuel supply was found exhausted and the fuel hose…Incident 20040511014939IBoeing 757231 · Cleveland, OH(-23) Passenger [privacy data omitted] flight 312 from cancun, Mexico to Cleveland, Ohio was found by crewmember to have smoked in the lavatory in violation of crewmember briefing and posted placards and signs. The incident happened during the descent into…Incident 20040511013839IBeech C90A · Roseau, MN(-23) On may 11, 2004, at 1904Z (1404 local), a Beech C90A owned by pellco, inc. and operated by anoka air charter, departed the left side of runway 34 while landing at the Roseau MN airport on a nonscheduled part 135 cargo flight. IFR conditions prevailed, a…Incident 20040511010019IMooney M20J · Bishop, CA(-23) A/c departed lone pine, CA (O26) and climbed to 10K and after retarding power to cruise, experienced low oil pressure and engine vibrations. Made precautionary landing on hwy 395 approx 6 miles south of Bishop, CA (bih). No damage to aircraft or…Accident 20040511009609ASnias AS350B · Skagway, AK(-23) Pilot reported initial illumination of the engine oil pressure warning light during descent from 2600 feet followed by the steady low rotor warning horn and the generator warning light illumination. The pilot entered autorotation and landed in the water…Incident 20040511009119IScwzer G164B · Delta, UT(-23) Pilot lost braking control of the l/h brake on landing. Aircraft departed the runway to the right hitting a ditch running parallel to the runway. Pilot reported that the brake had been marginal and not performing properly in the past few days.Incident 20040511008639IBell 206L1 · Abbyville, LA(-23) On may 11, 2004 at approximately 0920 local time, the pilot in command, while enroute to his next intended point of landing, elected to divert from that landing point, a helideck in the gulf of Mexico, and landed at SM28, a nearby helideck. The pilot in…Accident 20040511008149APiper PA28140 · Courtland, AL(-23) On final approach the aircraft hit a tree approximately 1500 feet from the approach end of the runway. The tree was approximately 30 feet high and well below the approach path. The aircraft flew into the ground after making contact with the trees. The…Incident 20040511007979ICessna 172N · Denver, CO(-23) Aircraft was being vectored to a practice ILS approach to runway 29R at jefferson county airport. Once the aircraft had been cleared for approach, the pilot reported a knocking noise in the engine and the loss of oil pressure. The aircraft landed in a…Incident 20040511007459IBoeing 747400 · Fairbanks, AK(-23) [privacy data omitted] capt. reported apparent heavy compressor stall on #1 engine just after V1 on takeoff from fai. Fai tower observed short burst of flame from #1 engine. Crew continued takeoff/climb, secured engine, dumped fuel and returned to fai…Incident 20040510035179IBeech A36 · Daytona Beach, FL(-23) On may 10, 2004, about 1230 eastern daylight time, a Beech A-36, N3670S, registered to and operated by a private individual as a title 14 CFR part 91 maintenance test flight, incurred a heavy vibration during climb and cruise, in the vicinity of Daytona…Accident 20040510029249APiper PA38112 · Oil City, LA(-23) On may 10, 2004, a Piper PA-38-112 single-engine airplane, N24007, was substantially damaged when it impacted terrain after takeoff from thacker's airport (5F8), near Oil City Louisiana. The solo private pilot was seriously injured. The pilot was…Incident 20040510025309IMooney M20R · Phoenix, AZ(-23) Just after touching down in a 90 degree gusting crosswind which was given to the pilot by the tower as 16 gusting to 23, the pilot lost control of the aircraft, ran off the right side into the infield then returned to the runway. Aircraft received…Accident 20040510009799APiper PA44180 · Julian, CA(-23) On may 10, 2004, about 2100 pacific daylight time, a Piper PA-44-180, N304PA, collided with mountainous terrain during cruise at Julian, California. Pan am international flight academy was operating the airplane under the provisions of 14 CFR part 91.…Incident 20040510009729ICessna 172RG · Ruston, LA(-23) CFI and student became distracted and failed to lower gear before landing.Incident 20040510009299IAmtr KOLBMK3 · Tatum, TX(-23) Aircraft ran out of fuel during unexpected IFR weather conditions. Pilot was unable to get into destination airport or alternate airport and ran out of fuel on way to his third airport.Accident 20040510009209ACessna 172P · Battle Ground, WA(-23) During a student's third attempt to land on runway 15 at Goheen Airport (W52), N54477, a CE-172P, landed long and did not stop on the runway surface. The airplane departed the end of the runway and came to rest in a ditch bordering an adjacent road. The…Incident 20040509031629ICessna 172N · Put In Bay, OH(-23) On first landing attempt aircraft bounced two or three times and the pilot executed a go around. The subsequent landing was normal. Pilot noticed damage to the propeller during a walk around of the aircraft. No maintenance personnel were available to…Incident 20040509019759IBoeing 737232 · Albany, NY(-23) On 05/09/04, delta flight 650, N314DA aborted takeoff due to #2 engine failure. At approximately 1248 aircraft was cleared for t/o, during t/o roll crew heard a loud bang with yaw to the right. Crew regained control of aircraft and takeoff was aborted.…Accident 20040509017912AAmtr G202 · Georgetown, TX(-23) The pilot in command of N202XS, a giles 202, flew at a steep final approach and struck N89SE, a diamond star aircraft, model DA-40 that was ahead and below him on final approach to runway 18, Georgetown airport, Georgetown, Texas. The 202XS ended right…Accident 20040509017911ADiamon DA40 · Georgetown, TX(-23) N89SE, a diamond star D-40 was on short final at approximately 50 feet, when 202XS, a giles 202 experimental, descending on a steep short final, struck him in the left wing which caused N89SE to lose total control. The diamond ended right side up on the…Incident 20040509015059IPiper PA18150 · Galesburg, IL(-23) [privacy data omitted] during landing rollout on runway 28 at Galesburg, IL the aircraft began to weathervane to the left, the aircraft then tipped up onto the right main landing gear, the aircraft ground looped and nosed over striking the propeller…Accident 20040509012909APiper PA12 · Hartford, WI(-23) On may 9, 2004, at 1605 CDT, a Piper PA-12, N2368M, registered to paul l. behrens, lost power on climb-out after takeoff from runway 18 at Hartford Municipal Airport, Hartford, Wisconsin. The aircraft sustained substantial damage from the resultant…Accident 20040509012899ARobsin R22BETA · Genessee, WI(-23) On may 9, 2004, at 1338 CDT, a Robinson R-22 beta, N215WW, registered to ww helicopters and operated by Mr. B. Mauer lost rotor RPM on approach to landing in a gravel pit 1/2 mile south of genesee, Wisconsin during a local part 91 flight. A hard landing…Incident 20040509009999IPiper PA24 · Coeur D Alene, ID(-23) The pilot had purchased the aircraft on 5/08/04 and was flying home to new kent, VA 23124-2622. When he tried to land at Coeur d'Alene, ID for fuel, he experienced a landing gear failure and then smoke in the cockpit. The gear would not come down-and…Accident 20040509009169AAmtr Kitfoxii · Broadview, MT(-23) On may 9, 2004, Mr. John m. nash, holder of an ATP certificate, crash-landed N308KF, an amateur-built Kitfox ii, 3 miles north of Broadview, Montana. The aircraft received substantial damage and the pilot (sole occupant) received minor injuries.…Accident 20040509008109APiper PA31350 · Morrisville, VT(-23) After traveling approximately 700-800 feet down the runway during a normal takeoff at Morrisville, VT, (mvl), the pilot observed the left engine not developing normal takeoff power and elected to abort the takeoff. Simultaneously, as engine power was…