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 19991008030159IBeech C23 · Houston, TX(-23) Aircraft bounced on landing then touched down hard on nose wheel causing it to collapse.Incident 19991008028889ICessna 172RG · Manassas, VA(-23) While taxiing near another aircraft, airman was watching right wing and hit a building with his left wing. Minor damage. No injuries.Incident 19991008028819IBeech 35B33 · St Charles, MO(-23) Pilot was practicing takeoffs and landings for upcoming commercial pilot asel certification evaluation. On the third landing to the runway, pilot admitted he was distracted during his landing and forgot to lower the landing gear.Accident 19991007046679ACessna A185E · Yakutat, AK(-23) After landing at the italio river landing strip near Yakutat, the airplane was decelerating on a roll-out when right wheel casting broke and departed the axle. The right axle dragged through the sand beach runway. The right wing impacted the sand…Accident 19991007043379ACessna 177 · Frankfort, KY(.4)On approach to the airport, the engine lost all power, and the pilot performed a forced landing to a field. The pilot stated that the airplane had a supplemental type certificate for automobile gasoline. Before the flight, the pilot added 15 gallons of…Accident 19991007040999ABell 206B · Slaton, TX(-23) On October 7, 1999, at 1801 local time, a jet ranger Bell 206-B iii helicopter, N21166, operated by the Texas dps, was substantially damaged during a pratice autorotation at Slaton Municipal Airport (F49), Slaton, TX. [privacy data omitted]The PIC, was…Accident 19991007040429ACessna 172P · Torrance, CA(-23) Pilot was high and fast on approach to 29L, flared and porpoised, hit tail, then landed hard on nose wheel. Initiated go-around, repeated same thing on second attempt. ATCT asked if assistance was necessary, pilot told them that nose wheel might be…Accident 19991007036939ABell 206B · Apache Junction, AZ(.19) On October 7, 1999, at 1015 hours mountain standard time, a Bell 206B, N6624N, experienced a loss of engine power and force landed in Apache Junction, Arizona. The helicopter, operated by Bell ford, inc., of phoenix, Arizona, sustained substantial…Incident 19991007031089IDoug DC982 · St Louis, MO(-23) On flight from ord to stl during climbout, tail compartment temp hight light came on. Crew initiated emergency checklist. Light stayed on. Crew initiated an emergency landing at stl. No damage to aircraft or injuries. At gate, contract maintenance was…Incident 19991007030249IPiper PA28R180 · Newport, AR(-23) [privacy data omitted] the landing gear was cycled several times, but the nose gear remained in its wheel well. The main landing gear operated normally. The aircraft executed a landing at Newport with the nose landing gear retracted. The pilot managed…Incident 19991007029819ICessna 150H · Ravenswood, WV(-23) Aircraft struck a dee during takeoff roll on runway 22.Incident 19991007029519ICessna 152 · San Jose, CA(-23) The pilot, a CFI at inbound aviation, departed runway 13R at rhv, with a student, to practice flight in the airport traffic pattern. After takeoff, at approx. 200 feet, the pilot observed the engine was not developing full power. She said she attempted…Incident 19991007029339ICessna 177RG · St Petersburg-C, FL(-23) On October 7, 1999, at 4:26 pm, a Cessna 177RG, N2006Q, registered to chart air inc., made an emergency landing at st. Petersburg-Clearwater international airport, Clearwater, FL., while on a 135 cargo operation. Visual meteorological conditions…Incident 19991007029319ICessna 177RG · Marianna, AR(-23) On oct. 7, 1999, at approx. 1745 CDT, a CE-177, N1521H, registered to gibson gist aircraft partnership, made a gearup landing at 6M7. Investigation revealed a hydraulic hose had blown causing depletion of all hydraulic fluid, therefore the pilot was…Accident 19991007028969AAirtrc AT502B · Bay City, TX(.19) On October 7, 1999, at 1620 central daylight time, an air tractor AT-502B airplane, N61768, owned and operated by aviation services unlimited of Bay City, Texas, was substantially damaged when it impacted terrain while maneuvering near Bay City, Texas.…Incident 19991007028669IBeech 1900D · Kansas City, MO(-23) On October 7, 1999, air midwest BE-1900, N242YV, departed Kansas City International Airport (mci) and returned to mci due to low fuel pressure. Maintenance at mci replace fuel boost pump and aircraft was returned to service. Incident #CE1999IAC0104 is…Accident 19991007028609AHughes 369E · Moreno Valley, CA(.19) On October 7, 1999, at 2005 hours pacific daylight time, a Mcdonnell Douglas 369E, helicopter, N991SD, was substantially damaged during an emergency landing at Moreno Valley, California, following an in-flight loss of directional control. The commercial…Accident 19991007028439ACessna 172 · Bethel, AK(.19) On October 7, 1999, about 0940 Alaska daylight time, a wheel equiped Cessna 172 airplane, N4762D, sustained substantial damage after being struck by a forklift at the Bethel Airport, Bethel, Alaska. The airplane was taxiing to the operator's facility…Incident 19991007028019IMooney M20K · Sacramento, CA(-23) Owner removed cowling to run engine on ground to check function of air conditioning pump. Owner had placed chocks in front of wheels and set parking brake. He then started the engine and exited the aircraft to visually inspect the air pump. After…Incident 19991007027619ICessna 402C · Providence, RI(-23) Pilot observed smoke coming from aircraft exiting runway 34 turning onto runway 23L (which was being used as a taxiway). Shut off fuel, secured engines and evacuated aircraft. Maintenance found right turbo seal failed. R + r turbo opps checked ok.…Accident 19991006044279AZinair CH2000 · St Louis, MO(-23) Upon arrival at Creve Coeur Airport found the a/c had been disassembled to the firewall with the propeller, engine and nose landing gear removed. Noted damage to the propeller tips and tearing and wrinkling of the firewall. Student PIC was interviewed,…Accident 19991006037309ADhav DHC8102 · Philadelphia, PA(-23) Allegheny commuter airlines flight 3653 (ALO3653), enroute from phl to abe, was 5-10 miles north of phi at 3,000' when it struck a flock of birds. Aircraft landed at abe without further incident. (.4) the captain stated that he was in cruise flight,…Incident 19991006033399ICessna 177RG · Aledo, IL(-23) IGL1920000005 while conducting a simulated engine out emergency landing, the flight instructor and student pilot became distracted during the landing approach and failed to lower the landing gear, resulting in a wheels up landing. The aircraft received…Incident 19991006029599IPiper PA42 · Las Vegas, NV(-23) Aircraft departed north Las Vegas airport and returned to land safely after cabin door opened in flight.Incident 19991006028849ICessna 150D · Binghamton, NY(-23) On October 6, 1999, N4149U, Cessna CE-150, departed laconia, new hampshire (lci) enroute to Binghamton, new york (bgm). The pilot told the Binghamton air traffic controller that he had a low fuel situation. The aircraft landed at 11:58 on runway 28. The…Incident 19991006028179IPiper PA60601 · Smoketown, PA(-23) On October 6, 1999, mike kuhn, 63429153, landed N15MH, a PA-60-601, gear up at Smoketown Airport, PA (37PA). Pilot stated he was landing to the west into the setting sun and when he looked down he could not tell if the three green gear lights were…Accident 19991005046309AN4779G · Weldon, AR(-23) During cruise portion of flight, the aircraft impacted the ground at a high rate of speed. Evidence of alcohol was discovered in cockpit during investigation. Pilot autopsy reflected a .13% blood alcohol content and a blood clot in a coronary artery.Accident 19991005044869APiper PA36285 · Brownfield, TX(-23) On October 5, 1999, at approx. 1700 local CDT, [privacy data omitted] operated as PIC a Piper brave PA-36-285, N4241U, owned by foshee spraying services, inc. of Brownfield, Texas. While spraying for boll-weevil eradications, approx. 5 miles west of…Accident 19991005043499ADoug MD11F · Newark, NJ(-23) During landing, center gear lower drag link failed causing retract cylinder to shear and loss of hyd systems #1 & #3. Center gear collapsed rearward damaging fuselage structure and skin punctures. Center gear removed and a/c was ferried to mem for…Incident 19991005042069ICessna 210M · Ann Arbor, MI(-23) Nose wheel came off on landing. Nut and cotter pin missing from nose wheel shaft. Last annual 2-99. Held discussions with mechanic who said the nut and cotter pin was in place during last annual inspection. No further action.Incident 19991005034209IMooney M20M · Bison, SD(-23) Investigation revealed that airplane landed on runway 29 at Bison. There were tire marks where the mains touched and where the nose wheel touched indicating that all three wheels contacted the surface at about the same time. There were three gouges in…Incident 19991005033169ILear 35A · Kingsville, TX(-23) Pilot stated that he forgot to put the landing gear down. He also stated that he didn't hear the landing gear down. He also stated that he didn't hear the landing gear warning horn because he was wearing clark headset.Incident 19991005032199IGulstm G44A · Fairbanks, AK(-23) Rt main tire had picked up a pk screw on take off. Went flat on landing fai runway 1 left. Runway 1L & 19R was closed due to aircraft on rw. Alaska arrival flight 144 had to divert to anc. Also Alaska flight 82 delayed takeoff for 40 min.Incident 19991005031499ICessna 750 · Lincoln, NE(-23) N950QS, CE-750, being operated as executive jet 50 enroute san jose, CA, to Washington d.c., diverted into Lincoln, NE, when the crew noticed a drop in the hydraulic quanitity indication. Maintenance found the #1 engine driven hydraulic pump case had…Incident 19991005031209IAMD Falcon · Denver, CO(-23) After rotation, both tires on left gear blew. Debris went through #1 engine. Aircraft continued takeoff, then returned and landed. Damaged landing gear, wheels, flap and engine.Incident 19991005031199IGulstm 500S · Corvallis, OR(-23) Pilot forgot to extend landing gear upon landing at Corvallis airport, Corvallis, Oregon (cvo). Pilot received no injuries and minor skin damage to bottom of aircraft. Special flight permit was issued for repairs.Accident 19991005029669ABell 206B · Centreville, AL(.19)On October 5, 1999, about 1200 central daylight time, a Bell 206B, N1285S, registered to third coast aviation, inc., operating as a title 14 CFR part 137 aerial application flight, crashed in the vicinity of Centreville, Alabama. Visual meteorological…Incident 19991005029249ICessna T210M · Albuquerque, NM(-23) N732VH departed runway started a southeast turn, declared an emergency, made a wheels up landing on taxiway h, slid across taxiway e and came to rest slightly off taxiway.Incident 19991005029179IBoeing 727230 · San Antonio, TX(-23) On October 5, 1999, a Continental airlines B727, aircraft, flight number 623, declared and emergency landing at San Antonio International Airport with a no. 2 engine shut down landing without further incident. Continental airlines captain's irregularity…Accident 19991005028599ACessna 210B · Tonopah, NV(.19) On October 5, 1999, about 2035 hours pacific daylight time, a Cessna 210B, N9609X, sustained substantial damage when it collided with terrain while on a left base leg for landing on runway 15 at Tonopah, Nevada. Majonnier enterprises inc. operated the…Accident 19991005028569ABeech 200BEECH · North Adams, MA(.19) On October 5, 1999, about 0545 eastern daylight time, a Raytheon BE-200, N208MS, was destroyed when it impacted terrain in williamstown, Massachusetts. The certificated airline transport pilot, and the certificated commercial rated co-pilot were fatally…Accident 19991004043919ACessna 421B · Montague, CA(-23) Left main landing gear (MLG) collapsed on roll-out causing a/c to veer off runway striking several parked a/c. teh a/c was declared totaled by the insurace company who after requesting received permission from NTSB to disassemble, and relocate the a/c,…Incident 19991004032349IDoug DC981 · Minneapolis, MN(-23) Shortly after takeoff, pilot notified ATC of smoke in cockpit. Aircraft returned to msp and landed without further incident. Smoke determined to be from left pack, and dissipated before landing when pack shut down. Left pack temperature control valve…Accident 19991004031829AAmtr RANSS10 · Benton, KS(.19) On October 4, 1999, at 1815 central daylight time, a draper rans S-10, N7868G, was destroyed when it impacted the ground after a loss of engine power and was consumed by fire. The 14 CFR part 91 flight had departed Benton airport (1K1), Benton, Kansas,…Incident 19991004030439IDoug MD88 · Pittsburgh, PA(-23) On November 4, 1999, at 1052E, delta flight #481 a MD-88, N928DL, s/n 49715 aborted takeoff at "pit" runway 28L due to a takeoff warning light and horn for a flag misalignment. The aircraft returned to the gate without incident. Maintenance inspected…Incident 19991004029499IBeech 95B55 · Lubbock, TX(-23) Five minutes after establishing cruise at 11,000' the door unlatched. The pilot could not hear the radio over the wind noise, so he declared an emergency and set 7700 on the transponder. He decended in VFR conditions and landed at lbb with no injuries…Incident 19991004029449IBoeing 737300 · Kansas City, MO(-23) On October 6, 1999, america west airlines' Boeing 737-300, N155AW, departed Kansas City International Airport (mci), and returned to mci due to an abnormal vibration. Aircraft landed without emergency equipment. Aircraft was ferried to phoenix, where #6…Incident 19991004029259ICamron V77CAMERON · Albuquerque, NM(-23) Pilot was attempting to make a landing when the balloon encountered a low level wind shear. The basket of the hot air balloon struck a mobile home and the impact injured a crew member. The balloon then made a hard landing injuring all three crew members.Incident 19991004028859IBeech C90 · Washington, DC(-23) N427DM was being marshalled out of a tight parking space at signature FBO at iad between a Learjet and a falcon 900 with a marshaller in front and a wingwalkter on each wing. N427DM'S right wing impacted the nose of the falcon. The pilot was wtaching…Accident 19991004028559ACessna 182R · Chester, CT(.19) On October 4, 1999, about 1750 eastern daylight time, a Cessna 182R, N121BG, was destroyed during a collision with a communications tower near killingworth, Connecticut. The certificated commercial pilot was fatally injured. Instrument meteorological…