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 19990925033899ICessna 150F · Lakeville, MN(-23) While approaching to land, the student was experiencing gusty, crosswind conditions. During the landing flare, the aircraft drifted left toward the edge of the runway. The airman attempted a go-around, but the left horizontal stabilizer struck one of…Incident 19990925033289IUnivar 108 · Grant, MI(-23) This is an update of this file reference a telephone conversation with the iic--inspector darling--on or about 11/16/1999: no action planned with the pilot as it was determined that the wires his aircraft hit were obscured by trees and brush. The owners…Incident 19990925032469IPiper PA28180 · Tippecanoe, IN(-23) Fuel starvation of the left fuel tank; attempt was made to switch to the right tank without engaging the electric fuel boost pump resulting in the fuel starvation to the engine. A precautionary landing was made in a corn field.Accident 19990925032309ABeech C35BEECH · Lone Grove, OK(.19) On September 25, 1999, at 1719 central daylight time, a Beech C35 airplane, N5818C, owned and operated by the pilot, was substantially damaged during takeoff roll from a field near Lone Grove, Oklahoma. The private pilot was not injured, and his three…Accident 19990925030469AAmtr SPACEWALKER2 · Conroe, TX(.19) On September 25, 1999, at 1715 central daylight time, a franklin space walker ii homebuilt airplane, N235FC, impacted the terrain following an in-flight separation of the left wing in level flight at the Montgomery County Airport near Conroe, Texas. The…Incident 19990925030269IGrob G103ATWINII · Minden, NV(-23) Student pilot failed to deploy spoilers during landing. Aircraft floated down and off the end of the runway into the brush. Subsequent to the above, the student received additional duel flight instruction in the use of spoilers.Accident 19990925029699AAmtr Dominator · Auburn-Lewiston, ME(.4) The pilot was practicing a 180 degree turn with 0 airspeed to a downwind condition at 100 feet AGL in his homebuilt gyroplane. He had successfully completed the maneuver once, and was attempting it for a second time. During the second attempt, the pilot…Accident 19990925028589ANamer SNJ5 · Nashville, TN(.19) On September 25, 1999, at 1100 central daylight time, a north American SNJ-5, N23ZH, collided with a tree and the ground, and burst into flames in a residential area of downtown Nashville, Tennessee. The personal flight was operated by the pilot under…Incident 19990925028309ICessna 152 · South Hill, VA(-23) Pilot stated that she was on a cross-country flight and got lost. She contacted ATC for assistance. ATC vectored her to avc. Aircraft ran out of fuel while in approach to avc. Damage to aircraft is not substantial. There were no injuries.Accident 19990925027909ACessna 172 · Panguitch, UT(.19) On September 25, 1999, at 1715 mountain daylight time, impact and postimpact fire destroyed a Cessna 172, N9103B, when it collided with terrain during an emergency landing after encountering heavy downdrafts following takeoff from Panguitch, Utah. The…Accident 19990925027889ARobsin R22ALPHA · St. George, UT(.19) On September 25, 1999, approx. 1840 mountain daylight time, a Robinson R22, N8360J, operated by ruesch machines, was substantially damaged when it collided with powerlines while maneuvering 7 miles northeast of St. George, Utah. The pilot, the sole…Accident 19990925027729AKaman HH43F · Phoenix, AZ(.19) On September 25, 1999, about 0650 hours mountain time, a Kaman HH-43F helicopter, N100PL, was destroyed when it collided with terrain at Phoenix, Arizona. The airline transport pilot and crewman were both fatally injured. Moseley aviation, inc.,…Incident 19990925027609IBeech 58 · Santa Rosa, CA(-23)Landing gear circuit breaker popped after selection of gear extension. Nose gear showed unsafe but no in-transit indication. Manual extend jammed. Nose gear collapsed on landing. Both props, fwd nose cheeks, nose doors damaged.Incident 19990924042589ICessna 402B · Chicago, IL(-23)The pilot lined up for take off on runway 31C on the right hand runway shoulder marking shoulder marking line instead of the center line. The pilot initiated a takeoff and struck a runway marker and directional sign with the right propeller, after…Accident 19990924040749ACessna 172RG · Orlando, FL(-23) I am larry d. enlow, an employee of the FAA, serving as an ASI, assigned to the Orlando flight standards office, Orlando, Florida. On September 24, 19999, I traveled to Orlando Executive Airport, Orlando, Florida, to investigate an accident involving…Accident 19990924040279ABeech F33A · Wildwood, NJ(-23) Took off runway 19 and circled to land. Attempted to land and upon contact with ground, engine would not throttle back. Initiated go around and landed short, attempted to throttle engine again. Engine throttled back but insufficient to control airplane…Incident 19990924039949IBeech 1900C · Ft Lauderdale, FLAircraft reported instrument out, request to reutrn to fll. A.t.c. in passing info mia center to fll ATCT reported engine out instead attitude indictator, f/o, acft landed without incident.Incident 19990924039229IPiper PA28R201 · Washington, GAOn Friday, September 24, 1999 at approximately 1445 local time, a Piper PA28R-201, N719JH, landed on runway 13 at the Washington Wilkes airport in Washington, GA. The landing gear was not extended prior to landing. The aircraft contacted the runway and slid…Incident 19990924033909IReno, NV(-23) Flight attendant reported pax had smoked on aircraft. Flight attendant did not provide a written statement. Pax told airport police that he was terrified of flying and he had smoked on aircraft. Airport police noted that pax had visibly wet himself.…Incident 19990924031409IBoeing 7373T0 · Salt Lake City, UT(-23) Large bird strike on the nose of the aircraft, the bird was then ingested in the left engine, the engine was shut down in flight and the aircraft returned to the airport. The aircraft landed without further incident.Incident 19990924031309IFokker F28MK4000 · Seattle, WA(-23) Just prior to complete ctop, acft left wing tip struck an improperly parked ground services vehicle. [privacy data omitted]Incident 19990924031029IReno, NV(-23) This is an interference with a crewmember. [privacy data omitted]Incident 19990924029869ICessna 172K · Burbank, CA(-23) Pilot arthur clark phillips in his written report stated that he was flying N79904 VFR from camarillo airport to big bear airport on 9/24/1999. He was cruising at 7500 ft., about 5 miles west of van nuys airport when the aircraft began shaking. He…Incident 19990924029159IFokker F28MK0100 · Little Rock, AR(-23) On September 24, 1999, at 0915 CDT, N1417D, a Fokker F-28-MK0100, registered to and operated by American airline as flight 526, enroute from dfw to sdf, reported smoke in the cockpit and diverted to lit. Aircraft landed without further incident with…Incident 19990924028299IAmtr Flightstar · Montgomery, NY(-23) Aircraft landed on runway 23, bounced off runway causing left main and nose wheel to depart the aircraft. Pilot state he "he never watched the airspeed."Incident 19990924028249IMooney M20K · Manassas, VA(-23) After landing the PIC applied brakes to make the first turn off, resulting in a blown right main tire.Incident 19990924028129IPiper PA32R301T · Poughkeepsie, NY(-23) Pilot reported a gear problem and requested a fly by. Tower observed left main gear extended while nose and right main retracted. Pilot lowered gear and got "three green". Aircraft landed and left main collapsed. Maintenance found left torque link bolt…Incident 19990924028109IAmtr Flightstar · Montgomery, NY(-23) An uncertficated operator, without a medical certificate flying an unregistered, two seat, ultralight style, experimental aircraft without an airworthiness certificate landed on runway 21 at Orange County Airport, Montgomery, new york. The pilot stated…Accident 19990924027829AMaule M4 · Anchorage, AK(.19) On September 24, 1999, at 1306 Alaska daylight time, a Maule ML-4 airplane, N4623T, sustained substantial damage when it nosed over during takeoff from the lake Hood strip, Anchorage, Alaska. The solo airline transport pilot received minor injuries. The…Incident 19990924027649ICessna 172RG · Denver, CO(-23) On 9/24/99 PIC schordje was giving a company fam ride to Mr. Hadelman for wings of Denver flight school. Mr. Handelman had not flown as an instructor for the school for over ninety days. Mr. Handelman had control of the aircraft as they taxied on to 17L…Accident 19990923045889APiper PA28161 · Covington, GA(-23) On a flight from orlando, FL. To peachtree dekalb airport in atlanta, GA, pilot miscalculated fuel burn, ran out of fuel over Covington, GA, and landed in a cow pasture. Pilot purchased fuel from a local airport, refueled the aircraft, and attempted to…Accident 19990923044349ACessna 421C · Santa Monica, CA(-23)On September 23, 1999, at 0702 PDT, N26585, a Cessna 421C, crashed on landing at Santa Monica airport after executing the runway 21 vor-a approach. On touch-down, the landing gear collapsed due to a hard landing and a post impact fire ensued. The pilot,…Accident 19990923040779AAmtr Pulsar · Belleville, IL(-23) On September 23, 1999 at approx. 1815 hours CST, Mr. Michael c. bosick was taking off for a local flight in his amatuer built Pulsar on runway 27 at flying dutchman airport (pvt) located in Belleville, IL. About 3/4'S the way down the runway at approx.…Accident 19990923037139AScwzer G164A · Animas, NM(-23) On 09/23/99 at 1330 MDT, N8731H, a Grumman ag cat model 164A, impacted the ground following take-off from a crop duster strip located in Cotton City, NM, causing substantial damage to the aircraft. The aircraft was operated under title 14 part 137 and…Accident 19990923036869ACessna 177 · St Petersburg, FL(.4) The pilot stated that while engaged in traffic reporting duties, at about 1,000 feet, 6 miles southwest of the albert whitted municipal airport, the engine started to sputter and there was a loss of engine power. The pilot further stated that she…Incident 19990923032969ICessna 150J · Galveston, TX(-23) On the afternoon of sept. 23, 1999, Cessna N60400, serial number 15070282, was on approach to the Galveston schols field airport. The aircraft lost power and made an emergency landing on a nearby roadway. Post inspection revealed that the nut which…Incident 19990923031339IEnstrm F28C · Fort Hall, ID(-23) While in cruise with all engine instruments in normal operational limits, a dull bang was heard followed by a violent shaking of the helicopter. An auto-rotation was perform. After landing it was determined that a piston connecting rod had penetrated…Incident 19990923029879ICessna A188 · Franklin, VA(-23) Aircraft departed Franklin airport, Virginia, (fkn) to conduct aerial spraying with full fuel and full hopper. Two hours into the spraying the pilot stated he looked at his watch and realized he was about to run out of fuel. The pilot returned back to…Accident 19990923028579ACessna A188B · Oxford, MS(.19) On September 23, 1999, about 1156 central daylight time, a Cessna A188B, N731RF, registered and operated by woodson flying service as a 14 CFR part 137 agricultural flight, crashed on landing at a private field in Oxford, Mississippi. Visual…Incident 19990923028049IJetair JETSTM4101 · Washington, DC(-23) Pull out of the gate on time flt. 7229, iad -orf. We took off and was in a climb to 3000 when a loud bang happened, after that we experienced a strong vibration of which we had no idea of what was causing it. Our first thoughts were the lav door came…Accident 19990923027879ABell 47G3B2A · Tremonton, UT(.19) On September 23, 1999, approx. 0900 mountain daylight time, a Bell 47G3B2A helicopter, N83246, registered to and operated by the pilot, was substantially damaged during a forced landing following a loss of engine power while maneuvering 1 mile north of…Accident 19990923027739AAmtr Glasairiii · Snelling, CA(.19) On September 23, 1999, at 1900 hours pacific daylight time, a homebuilt ciernia glasair iii, N153JC, experienced a loss of engine power while in cruise flight and force landed in a field in Snelling, California. The experimental airplane, owned and…Incident 19990923027489IBoeing 737230 · Kansas City, MO(-23) On departure aircraft would no pressurize. Pilot returned to mci and landed without incident. Maintenance performed operational checks and was unable to duplicate the problem on the ground. Follow-up investigations did not show a repeat of the problem.…Incident 19990923027119IBoeing 737500 · Kansas City, MO(-23) On 9/23/99, swaa, B-737-500, N514SW, departed st. louis international airport (stl) and declared an emergency for landing at mci, due to fire indication in APU. Aircraft landed and taxied to gate with no problem. APU fire detection system had previously…Accident 19990923026969ACessna 172F · Galena, AK(.19) On September 23, 1999, at 2205 Alaska daylight time, a Cessna 172 airplane, N5309R, sustained substantial damage during a forced landing about three nautical miles northeast of the edward g. pitka, sr. airport, Galena, Alaska, at 64 degrees 44.17…Accident 19990922047019ACessna 150M · Camas, WA(.4)The pilot reported that while on a long final approach with sun glare in his eyes, he mistook the runway number for the displaced threshold. On short final, the pilot realized that he was low and slow, and the addition of power near the end of the runway…Accident 19990922041079ABell 206L1 · Randolph, NY(-23) On 9/23/99 helicopter N17SP (bht 206 L1) piloted by scott norcutt made contact with a high tension power line approximately 200 feet above the ground near the vacinity of Randolph, NY. The first point of contact was made by the main rotor blades. The…Incident 19990922033619ISaab 340B · Minneapolis, MN(-23) On September 22, 1999, at 1720Z a mesaba aircraft N424XJ (SF-340) declared an emergency landing due to smoke in the cockpit. The pilots reported donning their smoke masks and proceeded to land without incident. Emergency vehicles were dispatched to the…Incident 19990922033189IPiper PA31350 · Minneapolis, MN(-23) Airman was taxiing through construction area. He maneuvered around a pile of trusses stacked on the left side of the taxiway. He then attempted to taxi clear of a van parked on the right side of the taxiway. The right wing tip struck the van. Consulted…Incident 19990922032809ICessna 182Q · South St Paul, MN(-23) Airman landed single engine sea aircraft on runway. Pilot forgot to lower the gear. Aircraft slid to a stop on the pontoons.