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 20040831023209AScwzer G164B · East Bernard, TX(-23) On August 31, 2004, at approximately 17:30 CDT, a Gulfstream, N8222K, model G-164-B s/n 617B, was substantially damaged during a forced landing following a loss of engine power, while dispensing fertilizer. The flight had originated from a private…Accident 20040831022119APzlwar PZL101 · Chazy, NY(-23) While in flight from franklin county state airport located in highgate VT (fso) to upper cumberland regional airport in sparta TN (srb) the aircraft had an engine failure that caused the pilot to make an emergency landing on a farm in the town of Chazy…Incident 20040831020669ICessna R182 · Yuma, AZ(-23) Pilot stated that she was enroute from montgomery field san diego, direct to Yuma AZ. The pilot stated that she was cleared to land on runway 17 and there was a slight crosswind of approximately 7 KTS. The pilot stated that she lowered the landing gear…Incident 20040830027049ISkrsky S70A · Los Angeles, CA(-23) On August 30, 2004, approximately 1240 pacific daylight time, a Sikorsky S-70A twin-engine helicopter, N160LA, experienced an uncontained number 2 engine failure upon reaching cruise flight. The helicopter landed uneventfully with minor damage at the…Accident 20040830021819AGulstm 112TCA · San Rafael, CA(-23) On August 30, 2004, about 1737 pacific daylight time, a rockwell international 112TCA, N44MH, experienced a total loss of engine power during initial climb from a private airstrip about 3 miles north of San Rafael, California. The pilot made a forced…Accident 20040830021459ABoeing 7272M7 · El Paso, TX(-23) On August 30, 2004, at 1905 MDT, a Boeing 727-2M7, N742RW, registered to art 21952 LLC and operated by custom air transport incorporated, received substantial damage when the right wing dragged on the runway on landing at El Paso International Airport,…Accident 20040829035459ACessna 177 · Warrenton, VA(-23) Pilot attempted to land on runway 14 at W66. Landed long then attempted to execute a rejected landing. During the takeoff attempt the tail of aircraft struck ground at an embankment. The vertical stabilizer, rudder and horizontal stabilizer separated…Incident 20040829028629ICessna 172 · Ash Fork, AZ(-23) Flight from chandler AZ to (kchd) st. george, ut (ksgu) pilot felt a slight vibration in the yoke, the engine made a loud noise and quit. The pilot landed in field about one mile north of I-40. The aircraft landed with no damage to it or the two…Incident 20040829027039ISaab SF340A · Washington, DC(-23) During ground operations at iad, the ground crew (delta global services) struck the terminal building (gate G7) with the aircraft wingtip. The aircraft sustained minor structural damage to the left wingtip and a torn de-icing boot. The factors…Accident 20040829026949ARobsin R22BETA · Northport, NY(-23) At approximately 1800 local time, August 29, 2004, a Robinson R-22-beta, N871CL, crashed in approximately three feet of water near [privacy data omitted], Northport, new york. There were two pilots on board. Both suffered fatal injuries and the aircraft…Accident 20040829026939APiper PA24180 · Ocean City, NJ(-23) On departure from runway 24 at Ocean City Municipal Airport, the aircraft broke ground and veered to the left and struck a wind tee, located between the runway and taxiway. The pilot then set the aircraft down in the grass between the runway and…Incident 20040829023829IPiper PA24250 · College Station, TX(-23) Landing gear collapsed on roll out after landing on runway 34 Easterwood airport (cll) TX. Minor damage to aircraft. No injuries.Accident 20040829023339ACamron A210 · Albuquerque, NM(-23) On August 29, 2004, at 0800 MDT, a cameron balloons A-210, N4503V, registered to star trail, incorporated, had a hard landing near Albuquerque, new Mexico, while on a sight-seeing flight. Visual meteorological conditions prevailed at the time, no VFR…Accident 20040829022299ACessna 172S · Erie, CO(-23) At approximately 16:00 gmt, at the Erie municipal airport, Erie, Colorado, the aircraft listed above was substantially damaged when the pilot made a hard landing on the nose of the aircraft. The pilot did not know that he had damaged the aircraft so he…Accident 20040829021469AEMB EMB135KL · Albany, NY(-23) Enroute to bos from yyz, flight 4568 experienced severe turbulence which caused the flight attendant to fall and be injured by the galley cart when it struck her ankle. Flight 4568 diverted to Albany where the flight attendant was met by paramedics and…Accident 20040829021439ABeech C35BEECH · Kalispell, MT(-23) On August 29, 2004, at approximately 1230 mountain daylight time (MDT), a Beechcraft model 35C, N63AC, was destroyed following an in-flight loss of control, and impacted a residential home in Kalispell, Montana. The certificated private pilot, who…Incident 20040829020869IBoeing 717200 · Flint, MI(-23) Around 07:am on August 29, 2004 an air tran aircraft N998AT was taking off from Flint Bishop international airport (fnt). About 20 miles east of fnt the pilot radioed the tower that he would be returning back to fnt because of radar failure. Once the…Incident 20040829019689IGardner, KS(-23) The operator (pilot) of the aircraft said this was his second flight in this aircraft. As the aircraft was being manuevered in level flight it stalled and made a wing-over maneuver. After recovery, the operator returned to the airport for landing. On…Accident 20040829019369ABeech C45H · Lakeville, MN(-23) Landing with 30 degree crosswind, pilot stated that just after touchdown a gust of wind raised the right wing and the aircraft veered to the left at which time the left wing contacted the VASI. The aircraft continued toward the left at which time the…Accident 20040829019329ABbavia 7ECA · Williams, AZ(-23) Aircraft made approach to the airport for the second crosswind landing of the day. The rt main gear touched down at the same time a strong gust hit the aircraft. The pilot then lost control. The aircraft ran off the runway hit a large rock spun around…Accident 20040828035239AAmtr Quickslverii · Rio Vista, CA(-23) During low cruise airraft wing struck tall bamboo bushes causing acft to lose control and strike road. (Reconstructed report) FSDO didn't investigate.Accident 20040828030339ACessna 172R · Atlanta, GA(-23) Aircraft N26486, a Cessna 172 with two men on board, departed pdk airport heading northeast from runway 20R at approx 0903. Shortly after takeoff with the aircraft at approx 75' above ground level (AGL) the aircraft made a rapid descent crashing into…Accident 20040828028069ABoeing A75 · Port Edwards, WI(-23) Pilot was giving a sight seeing ride flying north over the Wisconsin river at a maximum altitude of 50 feet. Pilot stated that he didn't see the power lines, although he was aware that they were there. When he initiated a climb he saw the power lines…Incident 20040828027829IPiper PA24250 · Ft Myers, FL(-23) This was a personal flight FAR part 91. The pilot was practicing touch and go landings. On this pass he forgot to lower the landing gear and landed gear up on the runway. Minor damage and no injuries.Incident 20040828027029ICessna 172M · Eagles Mere, PA(-23) The pilot flew the aircraft on a low pass over runway 24 at Merritt field. When the pilot elected to execute a go-around there was approximately 1,200 feet of runway remaining. During the go-around the aircraft touched down briefly (as the runway has an…Accident 20040828025809ACessna 172S · Leakey, TX(-23) N2477E departed uvalde, Texas at approximately 10:30 local time with kenny ray pool, holder of pilot certificate number 449864236, as pilot-in-command. At approximately 11:40 local time, it crashed into the terrain approximately 5 miles west of Leakey…Incident 20040828025589IPiper J3C65 · Shell Key, FL(-23) On August 18, 2004, at 1520 local time, a J3C-65, N70673, registered to thomas w. merrifield, had engine trouble and landed on Shell Key, Florida while banner towing. Visual meteorological conditions prevailed at the time and a flight plan was not…Incident 20040828025499IPiper PA34200T · Marks, MS(-23) The nose landing gear would not fully extend with the landing lever in the down position. The aircraft landed without the nose landing gear being fully extended. [privacy data omitted]Accident 20040828024029APiper PA30 · Cynthiana, KY(-23) Pilot stated that he was taking off on runway 11 at Cynthiana, KY airport at around 8:30 am local time on 8/28/2004, aircraft veered to left wing struck the windsock. Pilot did not know the cause, said he heard a growling noise, aircraft veered left and…Incident 20040828022779ICessna 150F · Wichita, KS(-23) Cessna 150-F, N7993F was cleared for landing at Wichita mid Continent airport runway 1L. At approximately 1.5 miles south of runway, loss of power was noted and aircraft landed in cultivated farmers field. No damage to aircraft or occupants. An A&P…Accident 20040828022552ABbavia 8KCAB · Prescott, AZ(-23) Two aircraft collided in flight while practicing aerobatics. The pilot of each airplane was the only occupant of that aircraft. The pilots were practicing aerobatics for a planned aerobatic competency demonstration flight the following day. Preliminary…Accident 20040828022551ABbavia 8KCAB · Prescott Valley, AZ(-23) Two aircraft collided in flight while practicing aerobatics. The pilot of each airplane was the only occupant of that aircraft. The pilots were practicing aerobatics for a planned aerobatic competency demonstration flight the following day. Preliminary…Accident 20040828022359AAmtr RV6A · Williamstown, NJ(-23) Landing on a grass airfield, the aircraft flared and the tail struck the ground. The aircraft lunged forward, the nose gear dug into the ground, and the aircraft flipped over forward on its back.Accident 20040828021859AAmtr KITFOX41200 · Payson, AZ(-23) After departing Payson, AZ (pan), on a return flt. To deer valley airport, phoenix, AZ (dvt), the pilot was cruising @ 700/800 ft (AGL) and 80 knts. As he approached a narrow canyon with steep walls and narrow width. He attempted to gain altitude when…Incident 20040828019599ICessna 175A · Panama City, FL(-23) While conducting banner tow operation, pilot noticed progressive knocking from engine, and loss of power. Pilot felt engine would not continue to develop power due to vibration and odor. Elected to land on beach after jettisoning banner. Landed with no…Incident 20040827027429IBoeing 757222(-23) Uala flight yvr-ord diverted to seattle-tacoma airport because of a flight control vibration. The aircraft landed without incident. Inspection of the aircraft revealed damage to the trailing edge wedge (aluminum & honeycomb) of the #6 slat, additional…Accident 20040827026889ARobsin R44 · Wildwood, NJ(-23) During landing operation the helicopter skid got caught under part of the dolly it was landing on. The pilot attempted to establish control but the helicopter, being stuck, rolled over to its side.Incident 20040827026319IAmtr HC1108 · Olympia, WA(-23) Aircraft struck runway threshold light cracking LH wheel pant and damaging approach light lense.Incident 20040827025899IBeech A36 · Batesville, MS(-23) The pilot raised the landing gear lever instead of the flap lever during landing. Before the correction could be completed, the aircraft landed without all the landing gear being down and locked. [privacy data omitted]Incident 20040827025619IMtsbsi MU2B36 · Chicago, IL(-23) After shutdown and the pilot departing the aircraft the right engine started on fire. The fire department was called and the fire extinguished.Accident 20040827024089ADhav DHC3 · Mcgrath, AK(-23) On August 27, 2004, at approximately 1630 adt, N197TT a Dehavilland DHC-3, equipped with tundra tires, was destroyed on impact and post impact fire when it collided with trees and mountainous terrain, about 35 miles west of Mcgrath, AK. The aircraft was…Accident 20040827023309AAmtr LANCAIR320 · Houston, TX(-23) Aircraft was departing runway 9 at Houston Southwest where it stalled shortly after take off and settled hard to the runway. Aircraft veered left where the left wing struck a taxi light and embedded in the leading edge. The aircraft crossed a ditch and…Incident 20040827021689IBeech 95B55 · San Martin, CA(-23) No.4 cylinder head of right hand engine separated from cylinder barrel due to worn threads causing broken fuel injector line and exhaust pipe resulting in nacelle fire. Pilot shut down engine, feathered propeller, and dove airplane to 160 mph to put out…Incident 20040827020419IBoeing E75 · London, OH(-23) Aircraft was landing on runway 27 at Madison County Airport, London, Ohio. On rollout the aircraft swerved to the left, leaving the runway and impacting a ditch along side of runway. Aircraft then flipped over upside down.Accident 20040827018879ALuscom 8A · Nampa, ID(-23) The pilot/flight instructor was getting an aircraft checked out. The pilot made a normal approach to landing on runway "29" at the Nampa airport. After touchdown the pilot failed to maintain control of the aircraft. The aircraft "ground looped" and…Accident 20040826023239AAmtr Searey · Dayton, TN(-23) Smooth water landing-touch down smooth. The hull fractured at rudder pedal and departed the aircraft. Aircraft flipped, trapping pilots. Both pilots exited after releasing dual seatbelts. Aircraft was recovered. Factory defect-hull laminates were laid…Accident 20040826022009ADhav DHC2* · Kodiak, AK(-23) The pilot indicated that during a takeoff from big river (approximately 150' wide) during his climb out the floats collided with a sand river bank and settled onto the tidal beach area of the river. The pilot and passengers exited the aircraft with no…Incident 20040826021529IAMD FALCON50MYST · Philadelphia, PA(-23) On taxi out at phl, pilot noticed odor. Less than 5 minutes later smoke was observed coming from cabin ceiling. Aircraft was shut down on taxiway. Evacuated 3 crew and 1 passenger through the main cabin door. The fire department was called. No injuries.…Incident 20040826021289IMooney M20C · Akron, CO(-23) Student pilot on cross country flight lost control of the aircraft on departure from Akron, CO. The aircraft went off the runway, crossed grassland terrain approximately 100 yards and through a three strand barb wire fence coming to rest on a dirt road.Incident 20040826020579IBoeing 7373H4 · Kansas City, MO(-23) Pilot reported: at 35,000' cabin reached 10,000' with cabin warning horn on. Engine bleeds were on and packs auto. No auto switched over to man ac & DC we paused at stby position, we had no control, also no control @ manual ac/dc position. Corrective…