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 19990204001019ANamer T28C · Joshua Trees, CAAcft departed van nuys en route to palm springs with another T-28 acft N628B, on 2/4/99. Both acft crashed under unknown circumstances at the 5,813 foot level of quaile peak 15 miles NE of palm springs. The wreckage was located on 2/6/99, the 2 pilots…Incident 19990203039389IBeech A65 · Keystone Height, FLAircraft onferry flight from opa-locka. Upon landing Keystone heights noseflingear begn to collaspe, and PIC used rudder to steer aircraft off runway into grass to prevent damaging aircraft more than necessary. Nose gear tranion found broken.Accident 19990203018809ACessna 150M · Paxton, IL(.19) On February 3, 1999, at 1031 central standard time, a Cessna 150M, N704BF, piloted by a private pilot, sustained substantial damage during a forced landing near Paxton, Illinois after a loss of engine power during cruise flight. Visual meteorological…Incident 19990203017789IBoeing 737353 · Albuquerque, NMAwxa F750103 feb diverted to abq. Pilot in pax compartment saw evidence of fuel leak from wing(right). Inspection on abq, ramp revealed numerous fuel leaks from #2 fuel tank upr./lower access plates. Awxa maint. Personnel brought to abq. To make airworthy…Accident 19990203013599ABbavia 7KCAB · Crystal River, FL(.19) On February 3, 1999, about 1515 eastern standard time, a Bellanca 7KCAB, N68573, registered to Crystal aero group, inc., ran off the runway and collided with terrain during takeoff at Crystal River airport, Crystal River, Florida, while on a title 14…Incident 19990203012129IBoeing 737247On February 23,1999, vanguard airlines, flight 817, a Boeing 737, was enroute from mci to dfw and turned back to mci due to hydraulic system failure. An emergency was declared and the pilot landed the aircraft at mci without further incident. The captain…Incident 19990203011279IBeech V35A · Wichita, KSThe bonanza rolled under engine power into a Cessna 421-B, the bonanza propeller and engine cowl struck the left wing tip fuel tank os the Cessna 421-B from the rear. Both aircraft were sybstabtuakkt damaged. During the post occurence investigation it was…Accident 19990203001199APiper PA18150 · Anchorage, AK(.19)On February 3, 1999, about 1030 Alaska standard time, a ski equipped Piper PA-18-150 airplane, N7875D, sustained substantial damage while taxiing at lake Hood, Anchorage, Alaska. The airplane was being operated as a visual flight rules (VFR) local area…Incident 19990202017819IBeech 95C55 · Burlington, IA(-5) After landing at the Burlington airport (brl) and while at a taxi speed the left landing gear collapsed followed by the right gear and then the nose gear. [privacy data omitted] Positive proof of a malfunction was not possible without extensive…Incident 19990202016229IBeech V35A · San Diego, CA(-5) A/c landed too fast and too long. Ran off west end of runway 28R.Accident 19990202015069ACessna 208B · Cody, WY(.19) On February 2, 1999, at 1711 mountain standard time, a Cessna 208B, N980FE, was substantially damaged following a gust of wind which nosed the airplane down while taxiing at yellowstone regional airport, Cody, Wyoming. The airline transport rated pilot,…Accident 19990202014519ACessna 152 · Odessa, MOStudent pilot simulated an emergency approach and landing procedures. On go around the acft engine failed to produce power and the acft crashed. Other circumstances are unknown. (-23) on February 2, 1999, Mr. Leo w. heiss operated Cessna 152, N67568, as pilot…Incident 19990202012809IBeech E18S · San Juan, Puerto RicoThe PIC stated once he was given clearance to land by San Juan act, he selected landing gear down and completed the before landing check list, everything appeared normal continuing the approach to final with a 30 degree flap setting touching down between 500…Incident 19990202011459ICulver TD2C1 · La Verne, CARetracting motor linkage failed on landing. Bent, distroted, broken into two pieces. No signs of prior damage or cracking.Incident 19990202010579ICessna 402C · Fairbanks, AKLt eng had power surge (tried to overboost) approx. 1500FT. After t.o. from vee pwr pulled by throttle smoothed, continued our flight to clk, at altitude lt eng. Had pwr loss but again smoothed out. Diverted flight to fyn, ceiling there 1500 ft, noted oil…Incident 19990202010369IZinair CH2000 · Austin, TXOn February 2, 1999, at 1700 hours a zenair MD CH2000, N410ZA owned by vec corporation of Delaware and operated by patrick Garrett, ran off the runway after an aborted landing. The aircraft contacted a runway marker/light sign. The aircraft sustained damage…Accident 19990202009049AArofal OH58C · Lakeland, FL(.19)On February 2, 1999, about 2150 eastern standard time, a bell OH-58C, helicopter, N151ES, registered to the city of Lakeland police department, and operated as a public-use aircraft, was destroyed during liftoff, at the Lakeland airport, Lakeland,…Incident 19990202008749ICessna 402C · Fairbanks, AK(-5) After executing the ILS to IL at fai, pilot attempted to exit the runway at intersection mike, per atc's request. As pilot taxied to mike, the weather deteriorated & he encountered dense ice fog. Believing that he was taxiing between the blue taxiway…Accident 19990202000999APiper PA32260 · Orlando, FL(.4)The pilot stated that while climbing after takeoff the engine lost power. He turned back to the departure airport. Witnesses observed the aircraft descending rapidly in a left turn and impact the runway with the left wing and nose area of the aircraft.…Accident 19990202000989ATcraft BC12D1 · Daingerfield, TXAcft went into a spin for unknown reasons while on a ferry flight. The pilot could not recover, and the acft crashed into some trees. Other circumstances are unknown. (-23) pilot was hired to fly aircraft from shv to prv. Near dangerfield, TX., pilot reports…Accident 19990201027869AAirbus A320232 · Las Vegas, NV(.19) On February 1, 1999, about 0710 hours pacific standard time, a passenger sustained a fractured hip on america west airlines flight 5 while en route between tampa, Florida, and Las Vegas, Nevada. The accident occurred while the aircraft was in cruise…Incident 19990201014489ISnias AS350B · Grand Canyon, AZ(.19) On February 1, 1999, at 1010 hours mountain standard time, an aerospatiale AS350B, N32GA, operated by silverado helicopters, inc., d.b.a. heli usa, experienced the sudden loss of the entire left side passenger window during descent over the Grand Canyon…Incident 19990201011839IDhav DHC8102 · Syracuse, NYOn Monday, February 1, 1999, at 0749 EST, a Dehavilland DHC-8-102 N808EX, glight 3841, operated by allegheny airlines, on deaprture from Syracuse, new york, experienced problems with the low cabin heat and pressurization. The #1 bleed heat caution light…Incident 19990201011589IMaule M5210CStudent pilot was practicing take offs and landings during gusty wind conditions, lost control of the aircraft on landing. Aircraft bounced back into the air,pilot elected to go-around,and after liftoff realized the extent of damage. Returned for landing.…Incident 19990201010559IDoug DC932 · Covington/Cinci, KYOn final #1 hyd. Pressure low light on. Landed with no problem. APU started, cabin filled with smoke. Secured air conditioning packs, smoke stopped. Evacuated all 34 persons through L1 door. No injuries.Accident 19990201001249ABell 206L3 · Gulf Of Mexico, LAPetroleum helicopters 1990 Bell 206L-3 helicopter tail rotor struck the wind sock on landing, and the rotor sustained substantial damage. No injuries were reported to the pilot/sole occupant. Other circumstances are unknown. (From .4) the helicopter's tail…Incident 19990201000969IPiper PA24250 · Reading, PAAcft landing gear collapsed on landing. In process of flying a coupled instrument approach to runway 36 at Reading, PA (rdg), pilot did not ensure that landing gear were locked down, on touching down, landing gear collapsed.Incident 19990201000959ICessna 152 · Anchorage, AKAcft crashed on landing. Other circumstances are unknown. (-5)pilot stated that upon landing rwy 6 aircraft developed strong shimmy during roll-out. The pilot, having never experienced such vibrations, and thinking that the engine mounts had failed, applied…Incident 19990131016649IPiper PA32300 · Belvidere, ILDuring cruise flight aircraft engine began to run rough, and the pilot observed a low engine oil indication. After landing at the nearest airport with the engine still running, the pilot observed a no oil pressure indication and shut the engine down. An…Accident 19990131001159AHughes 369D · Las Vegas, NVLas Vegas metropolitan police department 1979 Hughes 369-D helicopter was involved in auto rotation practice when the main rotors struck the tail boom. Other circumstances are unknown. (.4)the supervisor of the law enforcement helicopter unit reported that…Accident 19990131000979ABbavia 7GCAA · Alliance, NEAcft nose over and came to rest upside down while attempting to land in a field for unknown reasons. Other circumstances are unknown. (.4) the pilot flew over a friend's house and decided to land in a field adjacent to the house. The pilot stated that upon…Accident 19990131000949AMooney M20E · Albuquerque, NM(Tty)acft over rotated on take-off, the right wing dipped, and the acft crashed. Other circumstances are unknown. (.19) on January 31, 1999, approximately 1130 mountain standard time, a Mooney M20E, N5658Q, was substantially damaged when it impacted terrain…Incident 19990131000919ICessna T210M · Moorhead, MNAcft experienced engine failure at FL170. The pilot was able to keep the engine running by switching fuel tanks. Other circumstances are unknown. At an altitude of 15,000 ft. the engine quit. Pilot tryed to restart eng. But was unsuccessful. Aircraft was not…Accident 19990131000849ACessna U206G · Salem, MOAcft crashed under unknown circumstances after the pilot reported that the acft lost a vacuum pump and that the was disoriented. The pilot/sole occupant suffered fatal injuries. The acft was destroyed. (.19)on January 31, 1999, at 1212 central standard time,…Accident 19990130042099AAmtr Babyaced · Pleasant View, TN(.4)The pilot stated he was flying the experimental airplane on a friend's private airstrip near Pleasant View, Tennessee. During takeoff roll the airplane accelerated to approximately 35 knots and the main landing gear collided with a hole in the sod runway…Incident 19990130034299IPiper PA28R201T · Joliet, IL(-23) PIC mills departed chicago dupage airport (dpa), west chicago, IL on January 28, 1999 at 1340 CST on an IFR flight to louisville KY. Shortly after departure Mr. Mills noticed an emergency (smoke in the cockpit) with chicago ARTCC. N6140H was vectored to…Incident 19990130021149IAronca 65TL · Cat Spring, TXAircraft inspection revealed a slight bend rearward on 1 propeller blade and minor damage to cowl and landing gear fairings. Pilot suspects magneto switch failure. Aircraft awaiting maintenance to determine fault.Incident 19990130015799IBeech H18 · Detroit, MI(-5)A loss of power on the left engine occurred immedatley after take off and the landing gear retracted. The pilot decided to land on remining runway. With altitude vert low and slow airspeed the landing gear was selected down. The aircraft was too low and…Incident 19990130015429IPiper PA28R201 · Jamestown, ND(-5) On 01/30/99 at approximately 12:55 CST, a PA-28R-201, N175ND, owned by the university of north dakota and flown by cheng-hsien lian made an emergency landing on a paved road after experiencing engine power failure 12 miles nw of Jamestown, ND. The…Incident 19990130015379IBbavia 7ECA · Rayville, LA(-5) During landing roll out, student failed to maintain control of aircraft. Aircraft turned to right, departed runway and hit the ditch, damaging right main gear and one propeller blade. There was a crosswind 230 degrees at 10 knots.Incident 19990130013799IMooney M20K · Battle Mountain, NV(-5)1/30/99, Battle Mountain, NV, 2212Z, the initial problem stemmed from a high climb, causing the engine cylinder head temperature gage to read in the red. After lowering the nose and turning back the aircraft, the temperature returned into the green. The…Incident 19990130012469IBlanca 1730A · Melfa, VAOn landing rollout left landing gear collapsed without prop strike nor did wing touch the runway. Minor left wing damage caused by truck person clearing runway. Upper strut housing p/n 194280-50 was found cracked at welded area.Incident 19990130011179IMtsbsi MU300 · Owensboro, KYOn 1/29/99,misubishi, MU300, N703JH, experienced an uncommanded nose gear extension on descent at about 260 knt airspeed and 14,000 ft. MSL. In an effort to slow the a/c the crew retarded throttles, extended speed brakes and pitched the nose up. Both eng.…Incident 19990130010419IAmtr Challengerii · Laguna Beach, CA(-23) Mr. Husted was operating an aircraft as an ultralight in spite of the fact that it was required to be registered and operated as an aircraft under all applicable far's. pilot got lost, low on fuel and made an emergency landing on pch in Laguna Beach.…Incident 19990130009939ICessna R182 · Mcgregor, TXOn January 30,1999, at 1445 CST,a Cessna 182-R182, aircraft N202CT operated by darrell janecka,was involved in an incident. After crosswind landing on runway 22 of Mcgregor airport the throttle was pushed to full instead of being placed in the idle position.…Incident 19990130008759IPiper PA28161 · Santa Ana, CAOn January 30, 1999, at approximately 10:00 am PST, nancy m. credi was departing from John Wayne airport. During rotation the pilot was contacted by the tower and told that the main landing gears had fallen off. The aircraft landed with minor damage to the…Incident 19990130000939ICessna 172 · Apple Creek, OHPilot reported that the engine had quit and the acft crashed 1 1/S miles of the arpt and came to rest inverted. Other circumstances are unknown. (-5) pilot had flown for a least 1.5 hours before loss of engine power. Pilot declared an emergency with cak ATCT.…Accident 19990130000929AHughes 369E · Lake Elsinore, CARiverside sherif's department 1993 MD-369E helicopter was on routine patrol when it reported engine problems and made an emergency landing in a field. Other circumstances are unknonw. (.19) on January 30, 1999, at 1545 hours pacific standard time, a Mcdonnell…Accident 19990130000899ARobsin R22BETA · Pompano Beach, FLR-22 helicopter crashed under unknown circumstances while practicing auto rotations. (.4)the CFI was demonstrating a 180 autorotation with turn. The pilot did not meet the parameters listed in the maneuver guide for a touchdown or power recovery while going…Accident 19990130000889APiper PA28201T · Washington, NCAcft experienced engine failure on take-off. Attempted to land and crashed beside the rwy. Other circumstances are unknown. (.19) on January 30, 1999, about 1100 eastern standard time, a Piper PA-28-210T, N28235, registered to a private owner, operating as a…