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 20031221036059ICessna 210G · Chicago, IL(-23) Pilot reported that gusty winds distracted him to the extent that he simply forgot to lower the landing gear. Pilot heard the gear warning horn just before touchdown, but having never heard it before, decided to land rather than continue his confusion…Incident 20031221035649IEMB EMB145 · Rochester, NY(-23) On December 21, 2003 at approx. 2000 hr,[privacy data omitted] was disorderly, unruly, and interfered with crewmember's duties while aboard air tran flight 465 from roc to bwi. [privacy data omitted] Was removed from the flight by local sheriffs and the…Incident 20031221035019ISlinds 100180 · Cove, OR(-23) During a landing in a field the aircraft landing gear broke. Investigation of the incident revealed that the landing gear lower assembly broke off about one and a half feet above the wheel axle. The break occurred near the weld between the upper and…Incident 20031221034829ICndair CL6002C10 · Wichita, KS(-23) On December 22, 2003, aircraft N507AE flight 3701 while enroute from dfw to ict the flight crew experienced a no starter cut out indication on the number two engine. The crew shut the right engine down and declared an emergency. The aircraft landed…Accident 20031221034359AAmtr KR2 · St Marys, GA(-23) On 12/21/2003, at approximately 1523 hours, the pilot of N93PC with one passenger aboard, attempted to land at st. mary's airport (4J6), st. Marys, Georgia. During the landing sequence, the aircraft bounced several times upon contacting the runway. In…Accident 20031221034339ACessna 172K · Van, TX(-23) On December 21, 2003 at approximately 133O central standard time, a Cessna 172 single engine airplane N78189 was destroyed when it collided with terrain, then trees while approaching to land at Brady field near grand saline, Texas. The certificated…Accident 20031221033669APiper PA28R200 · Mountain Grove, MD(-23) Scene photographs and a witness statement indicate that the left main tire produced intermittent skid marks totalling approximately 275 feet in length during landing roll-out. The skid mark pattern changed as the tire's cord was compromised and the tire…Incident 20031221033479IBraero HS125700A · Elko, NV(-23) A loose wing deice system hose in the nose section of the aircraft allowed wing deice fluid to be introduced into the windshield de-fog duct causing accumulation of smoke on the flight deck.Accident 20031221033339ACessna T210N · Marfa, TX(-23) On December 21, 2003, at approximately 1640 CST local time, the pilot of a Cessna T210, N4689Y, lost power and subsequently made a forced landing in a field at approximately 2 miles north of Marfa airport (mrf) in the vicinity of Marfa, Texas. During…Incident 20031221032939IVarga 2150AMORISY · Welfleet, MA(-23) Pilot neglected to visually inspect fuel quantity on preflight inspection, departed chatham airport and experienced loss of engine power over Welfleet harbor after one half hour of flight. Attempts to maintain power by operating electric fuel pump and…Accident 20031220037439AAmtr Skyboy · Brighton, TN(-23) This was an on the scene investigation. Eyewitnesses to the accident stated that the aircraft was at an altitude of approximately 300-500 feet in level flight when the nose lifted up and then dropped, the aircraft began to spin to the right, a four to…Accident 20031220036319ARobsin R22BETA · Murrieta/Temecu, CA(-23) December 20, 2003, at 1530 pacific standard time, a Robinson R22 beta, N7189U, made a forced landing in mountainous terrain about 12 miles east of the French Valley Airport (F70), Murrieta/temecula, California. The private pilot operated the rented…Accident 20031220036199ACessna 208B · Covington/Cinci, KY(-23) Aircraft made take off on runway 27 at cvg. Pilot states that during climb, the aircraft became unstable about it's lateral axis. Pilot aborted the take off. The aircraft hit the ground, veered to the left of the runway in the grass. No injuries,…Incident 20031220036029IDoug DC982 · Chicago, IL(-23) An American airlines flight #349, MD-80, departing o'Hare airport on runway 32L at 210255Z, the atcs observed fire and debris from the number two engine and advised the pilot. The pilot declared an emergency (was given the option to land any runway),…Incident 20031220035022ICessna 208 · Homestead, FL(-23) On Saturday, 20 dec 2003, a Cessna caravan, N9639F and a Cessna 172, N5412D experienced a midair collision on final approach to runway 36 at Homestead general airport, X51. No injuries were reported. Each aircraft landed immediately after the collision,…Incident 20031220035021ICessna 172N · Homestead, FL(-23) On Saturday, 20 dec 2003, a Cessna caravan, N9639F and a Cessna 172, N5412D experienced a midair collision on final approach to runway 36 at Homestead general airport, X51. No injuries were reported. Each aircraft landed immediately after the collision,…Accident 20031220034789APiper PA28RT201T · Harrison, AR(-23) On 12/20/03 aircraft N69RS, s/n: 28R-7931305 on departure from flippin, Arkansas (flp) @ LCL time hit an unknown object (possible deer) with the right main landing gear after liftoff and experienced some control difficulty. Pilot burned off fuel before…Incident 20031220034629IAmtr Glasairshii · Smyrna, TN(-23) After a series of touch and go's the aircraft was making a full stop landing. The pilot lost control and the aircraft departed the runway. The left landing separated from the aircraft causing minor damage to the fuselage and left wing tip. [privacy data…Accident 20031220034369ACessna 152 · Louisburg, NC(-23) Aircraft was on a x-country flight when the engine seized. Instructor made forced landing in a large field. Aircraft hit a ditch, causing substantial damage to the aircraft. No injuries.Accident 20031220034089ABeech 95B55 · Lake Berryessa, CA(-23) The flight originated from lake havasu, AZ, and was to terminate at placerville, CA (pvf). The flight was planned for VFR enroute, the weather deteriorated and the pilot had to divert towards Lake Berryessa. The pilot was trapped in bad weather and…Accident 20031220033799AMooney M20E · Webb Lake, WI(-23) While performing at high speed, low altitude (approx 100-300' AGL), aircraft pulled up to a perceived vertical line then left wing tucked under and aircraft turned 180 degrees and nosed over. Aircraft impacted a frozen lake at an approximate 50-70…Incident 20031220033659IBbavia 7ECA · Plattsmouth, NE(-23) On December 20, 2003, in the afternoon between 1300 and 1400, citabira, N86983, had a propeller strike on a touch and go at Plattsmouth Municipal Airport.Incident 20031220033229IBeech 1900D · Clarksburg, WV(-23) After departure from ckb, air midwest flight #5539, a B-1900D noticed flaps were stuck at 17 degree position and after considering the runway icing condition at ckb and mgw and their inability to make a full stop landing at these two locations, elected…Incident 20031220033109IPiper PA23160 · Summit, AK(-23) Pilot landed at airport that is not maintained during winter months. On landing, nose gear was torn from aircraft, and both propellers bent. No injuries reported. [privacy data omitted]Accident 20031220032959ACessna 195B · Amarillo, TX(-23) On December 20, 2003, at approximately 1600 hours CST, while attempting to land on runway 20 at Buffalo Airport (1E7), a Cessna 195B aircraft, N6850D veered to the right after rollout and hit the embankment alongside the runway. The left main gear…Accident 20031220032349ABell 407 · Morehead, KY(-23) Medavac helicopter hit a stand pipe in Morehead, KY in a rv park camp site. Pilot stated that they had used the field in the past and the owner of the rv park had recently installed the pipe. Aircraft received minor damage to the tail rotor and to the…Accident 20031220031229ABell 206B · Henryetta, OK(-23) On December 20, 2003 at about 10:59 am central time a Bell 206-B N62HF, struck a guide wire between two power poles, with the aft end of the tail boom, while landing in a field next to an automobile dealership in Henryetta, OK. The pilot reported that…Incident 20031219033849IBeech B300 · Evansville, IN(-23) On 12/19/03 N1WV a Beechcraft 300 aircraft operated by the west Virginia department of aviation made an emergency descent and diverted to Evansville, IN due to a cracked windshield. The windshield was replaced.Accident 20031218037819ADoug MD1010F · Memphis, TN(-23) The right main gear failed on landing.Accident 20031218037569ACessna U206G · Thonotosassa, FL(-23) On 12/18/03 at approximately 1655 EDT, a Cessna 206, N603DK, registered and piloted by kimsey young, crashed while on a local flight when attempting a water landing at lake Thonotosassa, Thonotosassa, FL. Visual meteorological conditions prevailed at…Accident 20031218035369ALuscom 8E · San Jose, CA(-23) N1338B was on a personal solo flight from hollister municipal airport (3O7) to Reid-Hillview Of Santa Clara county airport (krhv). The aircraft made a normal three-point landing on runway 31L with calm wind. During the landing roll-out, the aircraft…Incident 20031218033379IBbavia 7GCAA · Martinez, CA(-23) Pilot reported while over benicia CA, engine at 2500RPM, engine developed roughness for ten seconds. Engine returned to full power. The the engine RPM dropped to 1200 RPM and then stopped. Landed at acme landfill Martinez, CA 2.5 miles from destination,…Incident 20031218033099IPiper PA44180 · Miami, FL(-23) Mr. Saddy barraza certificate #2668397 was giving flight instruction to Mr. Wayne luy who holds a private pilot certificate #2635864. Mr. Barraza stated that a normal take-off was executed, the aircraft reached the training area and the student…Incident 20031218031929IBeech J35 · Iraan, TX(-23) On December 18, 2003, N617Q, Beechcraft bonanza J35 was in route to junction, Texas at an altitude of 9,500 MSL. A loud bang was heard by pilot, james averett, and "something" was observed coming through the engine cowling and the windscreen became…Accident 20031217037759ARobsin R22 · Denver, CO(-23) Instructor and student pilot were taking off from Jeffco Airport in broomfield Colorado in a Robinson R22 helicopter enroute to scottsdale, AZ. On 12/17/2003 at 05:50 hours. Visual flight rules flight plan had been filed for the cross country flight…Accident 20031217037459APiper PA46500TP · Daytona Beach, FL(-23) At approximately 09:30 EST, Mr. Billy c. meazell departed the private airport at the spruce creek fly-in community near Daytona Beach, Florida on a VFR cross country flight to lufkin, Texas in his Piper PA-46A-500TP malibu meridian aircraft N155BM. On…Accident 20031217036439APiper PA11 · Gilbert, AZ(-23) During an attempted soft field landing, the aircraft nosed over and flipped onto its top. The aircraft appears to have had received substantial damage to the left wing. The left wing strut, tail, engine, prop, engine cowl, airbox, and windshield were…Accident 20031217036429AHughes 369D · Wheeler, HI(-23) During last flight from field site, pilot elected to pick up an external load without utilizing a long line. Included in the load were four ladders, one six feet long, one eight feet long, and two that were twelve feet long. After the aircraft departed,…Incident 20031217035799IAerosp AS355F1(-23) The pilot stated that on December 17, 2003 at approximately 16:27 he was the pilot in command of AS-355-F1, N69TL, en route to jfk airport when encountered inadvertent instrument meteorological conditions and heavy fog in vicinity of the robert moses…Accident 20031217034769APiper PA32260 · Brooklyn, IA(-23) Pilot obtained weather brief from prescott AZ fss. VFR flight was not recommended. Pilot left pwk enroute to ikv and encountered IFR conditions along the route of flight. Low ceilings and visibility with freezing drizzle and snow. Accident occurred…Accident 20031217034379ACessna 206H · Sanford, NC(-23) At 0500 on December 17, 2003, a Cessna 206H departed Sanford-lee county airport (tta) on an IFR flight in IMC conditions enroute to manteo, NC (mqi). There were 4 people in addition to the pilot aboard. IMC conditions prevailed at the time of departure…Accident 20031217033429AAmtr Wacoymf · Marathon, FL(-23) The pilot, Mr. Paul goodwin stated, that on December 17, 2003, at approximately 1650 local time, he was flying above aircraft around the Marathon airport area, and that after completing two consecutive landings at Marathon airport, during his third…Incident 20031217033269IAmtr Challengerii · Derby, KS(-23) While on downwind to runway 35 at 1K3 (Hamilton field, Derby, KS) the aircraft began losing power. The pilot turned right to enter a base leg and the engine quit. The pilot overshot base and turned south to find a suitable landing area. The engine then…Incident 20031217032949IMooney M20E · Newport, RI(-23) The pilot reported a normal final approach to runway 16 at Newport State Airport. He stated that he was unaware that he had forgotten to select gear down until heard the sound of the propeller striking the runway pavement, followed by the scraping of…Accident 20031217032299AAviat A1B · Hailey, ID(-23) Pilot lost control during landing roll and ground looped the aircraft. Pilot reported that during landing roll the aircraft veered to the left, at which point he attempted to correct by applying right rudder and brake. The left wing impacted the runway…Incident 20031217031069IBell 407 · Corale Gables, FL(-23) Aircraft experienced smoke in the cockpit due to a malfunction in the annunciator panel circuit board.Accident 20031216036839ABolkms BK117A3 · Okeechobee, FL(-23) On December 16, 2003, at 1908 eastern standard time, a mbb, bk 117A3, N911WJ, operated by cj systems aviation group inc., as a 14 CFR part 91 positioning flight, collided with trees and the ground during an inadvertent encounter with instrument flight…Incident 20031216036639ICndair CL6001A11 · Teterboro, NJ(-23) N95EB a Canadair CL-600 on an IFR flight plan, destination las vegas, NV. Attempted a takeoff from runway 24 at kteb. During the takeoff run pilot reported a normal acceleration to rotation speed. When he attempted to pull back on control yoke aircraft…Incident 20031216036239ICessna 152 · El Cajon, CA(-23) Student pilot practicing solo touch and go takeoffs and landings. Upon touchdown on runway 27L, student pilot failed to maintain directional control due to inexperience and aircraft drifted off runway to the left, striking a taxiway sign. Minor damage…Accident 20031216035399ABeech 99 · Mosinee, WI(-23) Pilot felt dme/loc equipment in aircraft was intermittently inaccurate. Commenced approach without being in stable position. Pilot felt nav indications were conflicting, and tuned vfr-only GPS to cross check. At some point LOC went full scale. Aircraft…