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 20040217005589AAmtr Lancairivp · Apache Junction, AZ(-23) The aircraft entered a flat spin @ approx. 2000' (AGL), did not recover, impacted the ground (kiat), and exploded. Both pilots received fatal injuries upon impact. A/c was destroyed.Accident 20040217004769ABeech B90 · Dodge City, KS(-23) On 02/17/04 a Beechcraft king air B90 with pilot in command [privacy data omitted] and two medical personnel departed the wichita mid-continent airport (ict) at 0210 local time on a part 91 repositioning flight to Dodge City (ddc), KS. The aircraft…Accident 20040217003759APiper PA28180 · Rich Hill, MO(-23) A non-instrument rated pilot and his passenger departed the allen county airport (K88), iola, KS, on a planned VFR flight to the spirit of st. louis airport (sus) in st. louis, MO. The pilot received a preflight weather briefing from the ict afss and…Accident 20040217003739AScwzer G164B · Tracy, CA(-23) Pilot was returning aircraft to trinkle ag flying, inc.'s north landing strip when he experienced a rough running engine. He made a forced landing in an alfalfa field, hit the top of a ditch bank with the landing gear, causing the aircraft to nose over…Incident 20040217002759IMooney M20R · Battle Creek, MI(-23) On departure from azo, this part 141 training flight experienced an unsafe landing gear indication. After burning excess fuel the Mooney-20-R, N909WM, landed on runway 31, Battle Creek, MI (btl) and the left main landing gear collapsed on roll-out.…Incident 20040217002649IGulstm 690A · Joplin, MO(-23) Pilot, with a passenger in right seat was practicing touch and go landings at the Joplin, MO airport, (jln) on runway 36. On the eighth touch and go, as the pilot was increasing power, the landing gear collapsed and the aircraft exited the runway to the…Incident 20040217002629ICessna 172P · Minneapolis, MN(-23) During 1st solo landing aircraft started to porpoise, student pilot pulled up on elevator added full power, veered off left side of runway and struck a taxiway light with propeller.Incident 20040217002419ILear 45LEAR · Indianapolis, IN(-23) Enroute to jeffersonville in, the pilot stated that he lost electrical power.Incident 20040217001969IDiamon DA40 · Albuquerque, NM(-23) On February 17, 2004, at 1100 MST, a diamond DA-40, N607C, registered to thysse company LLC, struck the runway with the propeller after the nose wheel strut separated from its attachment on landing at Double Eagle airport, Albuquerque new Mexico while…Incident 20040216017029ICleveland, OH(-23) Passenger [privacy data omitted] on swa flight 615 (mdw-cle) was allegedly smoked a cigarette during flight operations. The police interviewed [privacy data omitted] and he admitted smoking on the flight. [privacy data omitted] Was intoxicated and…Accident 20040216012229APiper PA28161 · Primm, NV(-23) On February 16, 2004, at 1359 pacific standard time, a Piper PA-28-161, N9199Z, departed the north las vegas (vgt) airport enroute to montgomery field, san diego, California. The personal cross-country flight did not arrive at the destination and was…Incident 20040216008279IPiper PA28140 · West Milford, NJ(-23) On this day Mr. Peter styczek, a private pilot, contacted the williamsport fss for a weather briefing. His plan was a VFR flight cross country from the orange country airport (mgj) to the Greenwood Lake Airport (4N1). While attempting to land on runway…Accident 20040216006099ACessna 172R · Batavia, OH(-23) On February 16, 2004, at 1600 EST, a Cessna 172R, N121UC, registered to eastern cincinnati aviation inc., made a hard landing at Clermont County Airport, Ohio (I69), while on a local student solo flight. Visual meteorological conditions prevailed at the…Accident 20040216004469AGulstm 690A · Oklahoma City, OK(-23) During departure roll on an IFR flight to little rock, the pilot experienced a flat left main gear tire approximately 1250 feet from departure end of runway 17L at Wiley Post (pwa). The aircraft veered left and departed the runway approximately 1750…Accident 20040216003149ACessna 182Q · Rozel, KS(-23) Weather reports, both infrared and water vapor satellite images and local residents indicate that there were low clouds in the vicinity of this accident scene. The surface temperatures in the area were below freezing and there was an AIRMET for the area…Accident 20040216003139ACessna 210E · Pittsburgh, PA(-23) Airworthiness directive (AD) 76-14-07/R2 applies to the aircraft's main landing gear saddles (left and right main gear). This AD has two basic parts, (replacement of the saddles and an annual dye penetrant inspection of the new saddles). The initial…Incident 20040216002799ICessna 172RG · Carbondale-Murp, IL(-23) [privacy data omitted] - on February 16, 2004, N9988B, a CE-172-RG, operated by a FAR part 141 flight school, was being utilized to administer a final stage check for commercial pilot certification. On board the aircraft was the commercial pilot…Incident 20040216002789ICessna 150M · Deem City, FL(-23) On 02/16/04 about 11:15 local, CE-150M, N9440U, piloted by student pilot, gary j. welvaert and CFI, louis s. shanley, cert. #102409872 aircraft collided with the terrain. Student pilot stated that he and instructor were practicing emergency engine out…Accident 20040216002029APiper PA34200 · Davis, WV(-23) Pilot stated that he was landing on runway 6 at windwood fly-in resorts in Davis, west Virginia, a small Private strip 3000 feet in length. The pilot hit a snow/ice covered area on the left side of runway 6. The aircraft ended up sliding onto a snow…Incident 20040216001949ICessna TR182 · Sherman/Denison, TX(-23) Aircraft was making a normal landing when the pilot noticed the right side was settling lower than the left. Pilot attempted to correct with aileron. Both main landing gear folded into retracted position. Aircraft slid off of runway into grass…Accident 20040216001499APiper PA28161 · Carroll, IA(-23) Approaching Carroll, Iowa, airport for runway 13, aircraft touched ground surface prior to runway causing nose gear to break away and propeller to strike ground. Undershot runway.Accident 20040215013679AGulstm 112 · San Juan, PR(-23) The mentioned aircraft N1261J departed from San Juan (tjsj) to st. croix (tisx) at approximated 2030Z 02/15/04. The pilot Mr. Prudoff sheldon, according with the information received was flying by himself at night over water, VFR, without a flight plan.…Incident 20040215006909ILear 35A · Chicago/West Ch, IL(-23) During landing rollout at Dupage county airport (dpa), the pilot in command applied brakes and had no braking action. Aircraft veered off right side of runway damaging one runway light. There was no damage to the aircraft. A subsequent inspection of the…Incident 20040215006669IPiper PA30 · Rockford, IL(-23) Pilot departed rfd, flew to jvl and landed without incident. Departed jvl for dbq and upon landing, retractable landing gear on PA-30, N7074Y would not fully extend. Pilot decided to return to rfd where PIC was not successful in his attempted emergency…Incident 20040215004289IPiper PA28161 · Camarillo, CA(-23) On 02/15/04 Piper PA-28-161, N80908 experienced an engine fire during start up. Inspection of engine and associated fuel lines revealed no anomalies. Interview with pilot cathy rezos revealed that she used an engine starting procedure that is not…Incident 20040215004019ICessna 150M · Austin, TX(-23) Pilot reported to air traffic control the loss of engine power. ATC cleared pilot to land at nearest airport 10 miles east of Austin, Texas. The engine failure was caused by cylinder number four breaking from the base. An examination of the engine…Incident 20040215003959IDiamon DA20C1 · Santa Fe, NM(-23) On February 15, 2004, at 1012 MST, a diamond aircraft industries DA-20-C1, (N641DC) registered aero meridian corporation; 1720 Louisiana boulevard, NE; suite 100; albuquerque, NM 87110 and operated by gregory peter deninno, [privacy data omitted]…Accident 20040215003529APiper PA23160 · Casey, IL(-23) The aircraft departed runway 04, shortly after takeoff the right engine lost power. The airman began a turn to return for a landing when the right engine regained partial power and the left engine lost power. The airman attempted to return to land on…Incident 20040215003379IAerovd L29 · Phoenix, AZ(-23) Shortly after takeoff the aircraft lost hydraulic power. The pilot was unable to extend the landing gear and landed gear up. The aircraft sustained minor damage and the pilot and one passenger were not injured.Incident 20040215002159IPropjt 200D · Pittstown, NJ(-23) Pilot on local flight entered traffic pattern and extended landing gear, but received unsafe indication on left main gear. Pilot exited traffic pattern and attempted emergency gear extension. Left main gear failed to extend and pilot landed with a…Accident 20040215002019ACessna 172E · Batavia, NY(-23) On Sunday, February 15, 2004 at approximately 1650 EST, a Cessna 172E aircraft, bearing registration number N369WP, registered to david blakeley and operating under 14 CFR part 91 on a local pleasure flight, collided with a snow drift while attempting…Incident 20040215001359IBeech B24R · Ashland, KY(-23) Pilot stated when gear was raised electrical power was lost. Pilot further stated he turned back to airport but gear would not come down. Aircraft landed gear up, awaiting on pilots written statement and witness statement.Incident 20040214033819IDoug MD88 · Syracuse, NY(-23) On February 14, 2004 at approx. 2244 a delta MD-88, N915DL, struck a parked, unattended, fuel truck while taxiing to the gate. Minor damage was sustained to the aircraft's right wing. No injuries were reported. The aircraft taxied to the ramp without…Accident 20040214021799ACessna 177A · Honolulu, HI(-23) Accident occurred during a night landing following an ILS approach in VMC. By the pilot's statement a significant gust caused the aircraft to assume a nose low attitude during the landing flare. There was a subsequent hard landing on the nose gear and a…Accident 20040214013739AAmtr THORPT18 · Cresent City, FL(-23) [privacy data omitted] departed from new smyra beach, FL. Airport at approx. 10:00AM on 02/14/2004 under IFR conditions. Metar-sgj 141635 z 01005KT 1/2SM OVC001 13/13 A3000. Aircraft crashed into lake Cresent at approx. 11:30 am, at high speed, pilot…Accident 20040214005659ACessna 172S · Riverside, CA(-23) On February 14, 2004, about 1900 pacific standard time, a Cessna 172S, N262TA, departed the taxiway while taxiing from landing and collided with terrain at Riverside Municipal Airport (ral), Riverside, California. The airplane was registered to irvin…Accident 20040214003499ACessna 177 · Sturgis, MI(-23) Pilot was reported as practicing touch and go landings. During landing the pilot reported that his aircraft wing tip struck the ground and slid off the side of the runway. Pilot was landing on runway 18. Winds were reported as 280 at 5 knots. [privacy…Incident 20040214002529IPiper PA28180 · La Cygne, KS(-23) PIC stated that, during his pre-flight inspection, he noticed the fuel level below the tabs and estimated about a three hour supply (in fact there is no reliable means to determine fuel quantity if the fuel level is below the tabs). On the final leg of…Incident 20040214002359ICessna 177RG · Indianapolis, IN(-23) On February 14, 2004 N27JS, a Cessna 177RG operated by [privacy data omitted] landed gear up at Greenwood Municipal Airport. [privacy data omitted] Was out on a local pleasure flight. He said that on his approach to Greenwood he smelled smoke (like…Accident 20040214001279APiper PA18150 · Naples, FL(-23) While landing on runway 23, Naples Municipal Airport (apf) pilot experienced wind gusts causing the aircraft to veer hard to the right at touch down. The pilot lost control and could not recover. The gear collapsed causing the propeller and wing to…Accident 20040213009539ABalwks FIREFLY11 · Cave Creek, AZ(-23) Pilot had just landed the balloon and was preparing to deflate the balloon. While the pilot was attempting to deflate the balloon the vent line broke. This allowed the balloon to become "buoyant" again. The winds dragged the balloon approximately 1/4…Accident 20040213006499AAmtr Corbenjracee · Elmer, NJ(-23) Pilot was on short final and stalled aircraft and impacted ground short of sod field. Landing gear was broken off fuselage and prop destroyed. Aircraft came to rest upside down. Pilot had a minor injury from contacting instrument panel with his chin…Accident 20040213003489ABbavia 8GCBC · Sunberg, MN(-23) While landing on a remote gravel road due to the fact the pilot had a sudden urge to use the bathroom, the aircraft veered to the right to avoid hitting a road sign. At this point, the right side of the main gear sunk into compacted snow, and the…Accident 20040213002879ABell 47G3B1 · Kremmling, CO(-23) On 02-20-04 pilot reported a hard landing had occurred the previous weed during practice autorotation landings. Damage included a sheared tailrotor short shaft, bent tailrotor guard, bent tailrotor blades and tailboom damage.Incident 20040213002689IBeech 95B55 · West Palm Beach, FL(-23) Right main landing gear failed to properly extend and lock in the down position, as the weight of the aircraft was put on the landing gear the right main gear collapsed.Incident 20040213002429IAirbus A310222 · Indianapolis, IN(-23) On landing roll out between approx 60-80 knots crew observed a flash on l/h side of a/c. after exiting runway they were informed by the tower that the #1 engine was on fire. There were no fire warnings in cockpit and did not observe any abnormal engine…Accident 20040213002039ACessna 172N · Upland, CA(-23) Pilot elected to abort the takeoff process when he determined the engine lost power at about 50 ft. and 2/3 distance down runway. Pilot extended full flaps in an attempt to arrest forward motion of aircraft. Pilot put aircraft back on runway. Aircraft…Incident 20040213001889IMooney M20J · Asheville, NC(-23) Pilot departed runway 34, Asheville Regional Airport (avl) in VFR conditions on IFR flight plan to kheg and noticed at about 3700 feet on climb out that he could not transmit. He then squawked 7700 declaring an emergency and made a down wind turn back…Accident 20040213001849ACessna 172M · West Dover, VT(-23) After contacting bridgeport automated flight service station for a weather briefing, pilot of N8880V, departed hartford/brainard (hfd) airport at approximately 7:45 pm on Friday February 13, 2004, for the West Dover, VT, MT. Snow airport (4V8), while…Accident 20040213001519ACessna A185F · Mesa, AZ(-23) Mr. Golder, pilot-in-command of N4836Q, a Cessna 185 was conducting touch-and-go's to runway 22R at Mesa Falcon field (ffz). During investigation, Mr. Golder stated that on last touch-and-go, the aircraft was still on landing roll when he diverted his…