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 19990717009229APiper PA28180 · Butler, MOAcft taking off, lost power, regained power, tried to return to arpt, landed in field and went through fence. (-23) a/c was substantially damaged during emergency landing due to power loss.Accident 19990717009219APiper J3C65 · Maple Lake, MNAcft departed Maple Lake, MN, on floats, lifted off the water then nosed into the lake. (.19)on July 17, 1999, at 1723 central daylight time,a Piper J-3C, N88593, was substantially damaged when the float equipped airplane impacted the water during the takeoff…Accident 19990717009209ACessna 150M · Glenns Ferry, IDCft crashed on takeoff from dirt road 10 n glens Ferry, ID. (-23)pilot loss control of aircraft on takeoff from a dirt road 10 miles north of Glenns Ferry, ID and came to rest in a ditch on the right side of road. Aircraft nose gear was sheared off, propeller…Accident 19990717009129APiper PA32R300 · Mammoth Lakes, CAPilot reported "pilot error", crashed in a field. (.19)on July 17, 1999, at 1317 hours pacific daylight time, a Piper PA32R-300, N1692H, sustained substantial damage when it collided with terrain during takeoff from Mammoth Lakes California. The commercial…Accident 19990717009119AAmtr RANSS12 · Nampa, IDSheriff reported acft N9230X crashed under unknown circumstances se of Nampa, ID, at intersections of bowmont and Robinson roads. Two fatalities. (-23)aircraft contacted ground in steep nose down attituded, 10 miles south of Nampa id. N43 27 610 W116 29 521…Accident 19990717009109APiper PA28R200 · Yorkville, ILFlying very low, engine sputtered, right wing tip caught ground, right wing ripped off, engine ripped off and acft impacted with ground (according to witness), 2 fatalities. (.19) on July 17, 1999, at 1300 central daylight time, a Piper PA-28-181, N5054F,…Accident 19990717009099AAmtr Bushbymii · Daytona Beach, FL1 Fatal when N102JB bushby homebuilt/experimental crashed 1 NE 44J (Daytona Beach, FL) Spruce Creek Airport. Crashed under unknown circumstances. No ATC involvement. (.19) on July 17, 1999, at 1615 eastern daylight time, a bushby m-ii experimental, N102JB,…Accident 19990717009089ABolkms BK117B2 · Houston, TXAir taxi, lifeflight crashed with three fatalities (other circumstances are unknown) near fresno, TX. (.19)on July 17, 1999, at 1231 central daylight time, a messerschmitt-bolkow-blohm BK-117-B2 helicopter, N110HH, operated as Life flight one, was destroyed…Accident 19990716047779ABell OH58A · Bastrop, LA(.4) The helicopter experienced a total loss of engine power due to a contaminated fuel system. Days prior to the accident flight, the refueling truck had been contaminated with water, and the accident helicopter had been filled with the contaminated fuel.…Accident 19990716042999ATmpson Navionb · Sulphur Creek, ID(-23) The pilot stated this flight was part of a mountain flying seminar held in mccall, ID. The Sulphur Creek airstrip is a private one-way mountain strip. They circled the strip at 900' AGL to check wind and conditions. Landing must be made to the west. The…Incident 19990716039579IAmtr EXEC162F · Tampa, FL(.23)On July 16, 1999, at 1535 EDT, an experimental amateur-built rotorway exec 162F, N43FL, registered to Mr. Paul j. pudela experienced a partial losss of engine power while inbound fora landing 3 miles east of vandenberg airport, Tampa, Florida. The pilot…Incident 19990716034179ICessna 172RG · Winsted, MN(-23) Gear up landing on runway 27 Winsted, MN. During conduct of biennial flight review. Pic/cfi refused to provide pilot and flight instructor records, flight times unknown. [privacy data omitted]Incident 19990716032599IDoug DC981 · Newark, NJ(-23) Inbound to neward international airport, the flight attendant reported a fire in the left forward galley oven. In flight emergency declared to ewr and requested CFR be available. Flight attendant workman used halon fire extinguisher to put out the fire…Incident 19990716032559IPiper PA46310P · Belmar/Farmingd, NJ(-23) Clamp on lih turbo compressor broke leaking hot gas onto a hydraulic line which sprayed fluid on to the turbo compressor. The aircraft caught fire in flight. Aircraft landed at blm. No injuries on board. Aircraft at rayco helicopters. NTSB (paul cox)…Accident 19990716031369ACessna T210M · Cedar City, UT(-23) Aircraft had an electrical failure resulting in a partial landing gear extension, damage was limited to wingtip and skin. Investigation into the cause of the electrical failure continues. Findings will be reported via an amendment to this report. (.19)…Incident 19990716025729ICessna 177 · Slocomb, AL(-23) On July 17, 1999 at 3:30 pm the pilot of N2294Y a Cessna 177 crashed while landing on a grass strip at freedom field airport in Slocomb, AL upon touch down the aircraft started to porpoise and the pilot could not regain control before reaching the end…Incident 19990716024339IDoug DC932 · Austin, TXGround crew marshalled aircraft into baggage cart.Accident 19990716022419ACessna 172N · Kissimmee, FL(.19) On July 16, 1999, at 0910 eastern daylight time, a Cessna 172N, N734YU, collided with the ground during landing at the Kissimmee Municipal Airport, Kissimmee, Florida. The airplane was operated by the student pilot under the provisions of title 14 CFR…Incident 19990716018729ICessna 120 · Andrews, TX(-5)N1972V, CE-120 enroute to EO2, lost power near Andrews, TX. Aircraft made an off airport landing. No damage to aircraft and no injuries to pilot, sole occupant. Pilot reported loss of oil pressure, high oil temperature and engine makeing metal to metal…Incident 19990716018719IBeech 1900D · West Palm Beach, FL(-5)Burned resistor in captain's audio amplified gave off smell of electrical smoke. No damage no injuries.Incident 19990716014779IDiamon DA20A1 · Wilcox, AZAirman did planning and preflight properly. Airman knew that he was running out of time, but elected to continue because the fuel gauge indicated 1/4 tank. Fuel was subsequently exhausted and an off airport landing was accomplished without any injury or…Accident 19990716009199ACessna 411 · Troy, MIStarted left engine normally, then started right engine. Right engine expolded, acft was evacuated. (.19)on July 16, 1999, at 1800 eastern daylight time, a Cessna 411, N660EM, sustained substantial damage from fire and explosions while the airplane was…Accident 19990716009169AHiller UH12C · Venice, FLPower failure in flight. Aircraft soft landed in gulf of Mexico.(.19) on July 16, 1999, at 0812 eastern daylight time, a Hiller UH12-C, N5317V, ditched into the gulf of Mexico following a loss of engine power near Venice, Florida. The helicopter was operated…Accident 19990716009079APiper PA32R300 · Vineyard, MAOverdue on flight from caldwell, NJ to Vineyard, MA. (-23) at this time no causal factor are known.Accident 19990715046089ADiamon DA20A1 · Sanford, ME(-23) A diamond aircraft industries, DA20-A1 (katana), N404EC, piloted by student pilot lauren k. graham, certificate #BB007817, lost direction control during the takeoff phase of a touch and go landing on rwy. 32 at Sanford, ME. Aircraft departed left side…Accident 19990715042709ACessna 150H · Granville, NY(-23) On final to runway 16, pilot misjudged rate of descent and landed 30 feet short of runway, hitting grave stone in cemetary. A/c came to rest 100 feet down runway. Damage to a/c included propeller, tore nose gear from a/c, tore lower fuselage skin from…Incident 19990715042019IEMB EMB145 · Cleveland, OH(-23) [privacy data omitted]Incident 19990715039769IPiper PA12 · Albany, GAAircraft landed on a touch and go, rolled about 800 feet, and ground looped, making a left 270 degree turn and coming to rest on the left side of runway 16.Incident 19990715034479IGrumav S2F · Mesa, AZ(-23) While descending, the pilot noticed a lack of aileron/roll control. Pilot notified ffz tower and pattern traffic then continued decent utilizing a symetrical thrust of engine. Pilot landed @ ffz uneventfully with no damage to aircraft. Subsequent…Incident 19990715034419IPiper PA31325 · Battle Creek, MI(-23) See attached faxed statment from pilot dated 7/21/99. Amended 09/13/99 to update block 22. The following is from david d. faust: damage to N3591P pa 31-325) date: July 15, 1999, place: north ramp area butler county/k.w. scholter field (btp) personnel:…Incident 19990715027049ICessna 172N · Smithville, TXJohn c. babb (PIC of N739ZY) departed georgetown airport (T04) in route to austin muller airport (aus) with one passenger on board. While flying north betwen Smithville, TX. And lagrange TX. The engine sputtered and lost power. John (PIC), went through the…Incident 19990715025299IBoeing 757223 · El Paso, TXOn July 15, 1999, at approximately 10:44 am MDT, American airlines, flight 1280, a Boeing 7570223, diverted into El Paso, TX on a flight from lax to dfw due to a strange odor in the cabin. Maintenance determined the odor came from the cabin video. The video…Incident 19990715023829ICessna 182R · Clarksburg, WV(-23) Pilot lost control of aircraft after landing on runway 3. Aircraft veered to left and struck a taxiway information sign which sheared off the left main wheel assembly at the spindle attach point. No reason for the loss of control is apparent.Incident 19990715023809IPiper PA44180 · Leesburg, VA(-23) After touchdown and rollout on runway 17 aircraft hit 2 deer, one with each prop. Minor damage.Incident 19990715022879IBeech A36(-23) Upon takeoff, the door immediately after the aircraft left the ground. The pilot elected to land on the remaining runway. The pilot did not extend the landing gear. There was damage to the gear doors, aircraft skin, antennas, and the propeller. This…Incident 19990715022529ICessna 310 · Detroit, MI(-5)Practing touch and go landings on 23R and yip. Selected gear down - no green - lifted floor board and checked gear box - cranked gear down - no green - mirror showed gear down - tower confirmed - landed on mains w/ stall horn on - nose gear lowered and…Accident 19990715022379ALet L23 · Jacksonville, FL(.19) On July 15, 1999, about 1400 eastern daylight time, a Let blanik L-23 glider, N254BA, registered to the north Florida soaring society inc., collided with a tree while on approach to the Herlong Airport, Jacksonville, Florida. Visual meteorological…Incident 19990715022339ISaab 340B · Victorville, CA(-23) At 19000', right generator light illuminated, started loosing engine instruments on right side (prior to generator light). Light went out, right essential light came on, smelled smoke, declared emergency. During troubleshooting, following gauges inop…Incident 19990715022299IPiper PA32R300 · Fairbanks, AK(-23) The circuit breaker popped when the pilot selected gear up and did not allow the pilot to either retract or extend the gear. The lights were also rendered inop. The pilot tried to reset the breaker unsuccessfully. The fai tower confirmed that the gear…Incident 19990715022109IBbavia 7AC · Indian Trail, NCPilot was flying airplane fronm the rear seat. Normal landing in calm winds, during roll out airplane started to veer to the left. Pilot applied full right brake and full right rudder but was unable to correct condition. Pilot stated that the left brake…Incident 19990715019049IBeech 1900D · Kansas City, MO(-5)On 7-15-1999, at 11:11 on the taxi way of Kansas City International the pilot amw 691 declared an emergency, requested crash trucks, and advised that the aircraft had a left engine fire. The pilot advised that the aircraft had been evacuated due to a left…Accident 19990715009869AAirbus A300B4605R · New York, NYAircraft made hard landing and damaged the tail structure. The NTSB has upgraded this incident to an accident due to the substantial damage the aircraft sustained. No injuries were reported. (.19) on July 15, 1999, about 1720 eastern daylight time, an Airbus…Accident 19990715009349AHughes 269A · Juneau, AKAcft crashed on landing and sustained substantial damage, other circumstances are unknown. (-23) high density altitude problem. Pilot was unable to hold rotor RPM, the aircraft settled, the rotor contacted rising terrain and rolled resulting in minor injuries…Accident 19990715009339ACessna 172K · Taft, CA(.4)On July 15, 1999, at 1800 hours pacific daylight time, a Cessna 172K, N46451, sustained substantial damage when it collided with power lines and trees during an aborted landing at Taft, California. The instructional flight was conducted under the…Accident 19990715008959APiper PA32300 · British Columbi, CNAcft crashed under unknown circumstances, the 2 POB suffered fatal injuries, the acft was destroyed by fire, other circumstances are unknown.Accident 19990714044119ACessna 172L · Montezuma, IA(-23) Pilot landed the a/c downwind on a grass runway and was unable to stop before going through a fence and coming to rest in a ditch. There were no injuries, but the aircraft received substantial damage.Incident 19990714023329IPiper PA23250 · Farmingdale, NY(-23) Pilot landed on runway 19 at frg, exited runway, proceeded to general aviation area, but re-entered the active runway without authorization. He then taxied on access road and struck speed limit sign causing minor damage to left wing leading edge.Incident 19990714022959IPiper PA24250 · Denver, CO(-23) According to the pilot he departed front range airport during the hours of darkness. During the start and runup check he discovered that the gear down light went out anytime he turned on the naviation and panel lights. Knowing this he departed front…Incident 19990714022149ISaab 340B · Erie, PA(From -23) first officer's yoke map light shorted out causing sparks and smoke. Maintenance personnel found rheostat bad.Incident 19990714018239IBeech A36 · Banning, CA(-5)The pilot reported that during the enroute trip to santa maria, California, he was on flight following and his reported altitude was at 11,000 climbing to clear the mountains. The engine quit running, he performed emergency procedures (switched tanks) and…