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 19990808011039APiper PA28161 · Chicago/Schaumb, ILOn takeoff roll, 600' from threshold of rwy 11, acft veered left off rwy, across taxiway, across ramp area, struck two acft, and stopped 20' from terminal bldg, instructor pilot unable to overpower student pilot, 2 minor injuries, N23661 struck N32281 and…Accident 19990808011019AAviat PITTSS1S · Coushatta, LAWitnesses reported that the acft was attempting to perform a double loop but was too low, and the acft crashed straight to the ground, the 2 POB suffered fatal injuries, the acft sustained substantial damage, other circumstances are unknown. (From .19) on…Accident 19990808010969ABbavia 7GCAA · Titonka, IAPilot made a low pass in the acft near the family FAR, and the horizontal stabillizer struck a tree, the acft crashed into a corn field and sustained substantial damage, the pilot/sole occupant suffered a fatal injuries, other circumstances ae unknown.…Accident 19990808010959APiper PA28R180 · Seven Springs, PAAcft crashed into a wooded area shortly after take-off, the 2 POB suffered fatal injuries, the acft was destroyed, other circumstances are unknown. (-23)see attachmentAccident 19990807043899ADoug DC1010F · Memphis, TN(-23)No narrative givenAccident 19990807041892ADhav DHC6300 · Ketchikan, AKSeaborne aviation air taxi (float plane) was parked at the dock when it was struck by N224SA, another seaborne aviation DH6 air taxi (float plane), which was starting its engines while parked at the dock, N288SA sustained substantial damage, N224SA has minor…Accident 19990807041891ADhav DHC6300 · Ketchikan, AK(.4)A pair of float equipped, twin engine airplanes were each parked parallel to a dock. The airplanes were separated by about eight feet, one in front of the other. Both airplanes, operated by the same company, were preparing to depart on sightseeing…Accident 19990807040859ACessna 172RG · Celina, TX(-23) The attempted takeoff was from a grass surfaced, private airport, from which the pilot had no previous experience. He elected to utilize the last 1100 ft., approx., of the total 1900 ft. length available because he considered the unused portion as being…Incident 19990807032529ICross Keys, NJ(-23) Name: michael mcgowan [privacy data omitted] experience: 10,000+ jumps; club affiliation: freefall adventures, equipment: main=stilletto 135, reserve=tempo 120; pilot chute deployed however the main did not. Subject "cutaway" from main chute and…Incident 19990807029949IFokker F28MK0100 · Minneapolis, MN(-23) After takeoff and gear retraction, nose gear light failed to go out. Gear cycled, light remained on. Reseated and relamped, operation check normal.Incident 19990807026909IPiper PA24250 · Grand Prairie, TXOn August 7, 1999, at approximately 8:49 a.m. CDT, a Piper (PA-24-250) N7105P, owned by Mr. Wayne ernest greer, mde a gear up landing when the pilot forgot to lower the landing gear. This was a personal flight in visual flight ocnditions and no flight plan…Incident 19990807026849IPiper PA28140 · Fasons, NCOn August 07, 1999 I was dispatched to the accident of a Piper P-28-140 N6791W. I arrived on the scene at about 10:15 am on August 08, 1999 with Mr. Roger wilhoit another inspector from this office. Mr. Wilhoit took photos of the scene and interviewed mr.…Incident 19990807024419IMooney M20K · Sacramento, CA(-23) On 08/07/99, at 1420 PDT, a Mooney M20K, N321RM, registered to ronald louis dona departed Mather field (mhr) enroute to cameron park (O61). After the pilot initiated landing gear extension, he noticed the landing gear was not fully extended. Another…Incident 19990807024389ICessna 177RG · Zelienople, PA(-23) Pilot stated he forgot to lower the landing gear and he thought that the gear up warning horn he heard in the flare was the stall warning.Incident 19990807023759ICessna 152 · Mountain View, CA(-23) On August 7, 1999, at approx. 1615 PDT, a Cessna 152, N68791, operated by Mr. Richard craig moore, a certificated private pilot, made an emergency landing at Moffett faf, CA (knuq) short of runway 32R. On approach to landing the aircraft struck the…Accident 19990807012619AHughes 269C · Westport, ORSchweizer 269C helicopter was reported missing after it took off from oysterville, OR, on 8/8/99, an alnot was issued, but the alnot and search were cancelled as of 8/16/99, the pilot/sole occupant is assumed to have suffered fatal injuries, all other…Accident 19990807011669ACessna A188B · Bettles, AKAcft crashed on landing and sustained substantial damage, other circumstances are unknown. (-23)on August 7, 1999 a tailwheel Cessna A-188B, N731UW sustained substantial damage while landing at a remote gravel strip approximately 50 miles north of Bettles,…Accident 19990807011189APiper PA18A150 · Anaktuvuk Pass, AKAcft crashed under unknown circumstances while enroute to a hunting camp 20 miles east of galbraith lake, the wreckage was located inverted and burned, the pilot/sole occupant suffered fatal injuries, other circumstances are unknown. (-23)it appears from the…Incident 19990807011099ICessna 310P · Concord, CAAcft clrd to land rwy 19R, upon roll out, left main gear collapsed, acft slid off rwy onto infield. (-23) on August 7, 1999, a Cessna 310P, N5862M, serial number 310P-0162, departed san carlos CA, for buckanan field, Concord, CA. The flight and approach were…Accident 19990807011079ACessna TU206A · Durango, CO(.19) On August 7, 1999, at 2359 mountain daylight time, a Cessna TU206A, N4835F, sustained substantial damage went it departed the side of the runway during landing roll at Animas air park, Durango, Colorado. The commercial pilot and his four passengers were…Accident 19990807011029AMooney M20J · Gainesville, MOAcft crash-landed on Missouri hwy 181, circumstances unkn, 2 serious injuries. (-23) on August 7, 1999, N11652 was observed on final approach to runway one with the landing down and at what appeared to be a high rate of speed. At the time of the accident the…Accident 19990807010949ACessna 177 · Wagoner, OKAcft took off and turned to the east then crashed and burned, the 2 POB suffered fatal injuries, the acft was destroyed, other circumstances are unknown. (.19) on August 7, 1999, at 1255 central daylight time, a Cessna 177 airplane, N29571, was destroyed upon…Incident 19990806027169ICessna 310D · Ottumwa, IA(-23) After take off, Mr. Struck tried to raise the landing gear. During this process, both pilots heard a noise, that one called a loud pop. The instructor, Mr. Keeley paris said he could see a problem with the nose gear by looking in the mirror located on…Incident 19990806025069IBeech 100BEECH · Mokuleia, HI(-23) PIC john p. tucker, certificate #557885108, commercial pilot had picked up 9 parachute skydivers. He started to taxi from the east end drop zone parking area making a 180 degree turn back to the active runway for takeoff. As he was turning back towards…Incident 19990806023339IRobsin R22BETA · Cheyenne, WY(-23) Mr. Mcfaul stated that just after take off the aircraft began to shudder. The pilot reduced power and turned to return to the airport. At this time the pilot observed a open area and set up an approach. The aircraft hit left side first and bounced three…Incident 19990806019429IAmtr Lancair · Mc Call, ID(-5)Pilot lost control of aircraft and ran off runway after an aborted take-off. The aircraft was approximately 20 feet off the ground and had a density altitude of 7200' when pilot stated the momentarily lost power. Ground checked engine with a 10 RPM drop…Accident 19990806011699ACessna 172P · Chicago/Waukega, ILAcft bounced several times on landing and sustained substantial damage. (.19) on August 6, 1999, at 0930 central daylight time, a Cessna 172P, N933LA, experienced a nose gear collapse during a bounced landing at the Waukegan Regional Airport, Waukegan,…Accident 19990806011209ACessna 150M · Sikeston, MOAcft departed sikesten rwy 2 for local training flight, acft lost power, pilot landed straight ahead into newly plowed field, acft flipped on back on rollout. (-23)follow-up revealed there was a stuck exhaust valve in one of the cylinders. Valve released upon…Accident 19990806011069ACessna 182P · Dorrance, PAAcft hit high tension wire, impacted ground, one person thrown from acft, 2 POB unkn injuries at this time. (.19) on August 6, 1999, about 1146 eastern daylight time, a Cessna 182P, N4352P, was substantially damaged after impacting wires, while performing a…Accident 19990806011059ABeech V35B · Elizabeth, COAcft experienced a rough running engine then crashed under unknown circumstances 5NM east of Elizabeth, CO. (-23)on August 6, 1999, at 1200 mountain daylight time, a Beech V35B, N3059W, conducted a forced landing when the engine lost all power approximately 5…Accident 19990806010979ACessna 150F · Currituck, NCAcft crashed under unknown circumstances, the 2 POB suffered fatal injuries, the acft was destroyed. (.19) on August 6, 1999, about 1200 eastern daylight time, a Cessna 150F, N7059F, registered to a private owner, operated as a 14 CFR part 91 personal flight,…Incident 19990806010929IBeech E18S · Fort Smith, ARSpringdale air service cargo acft landing gear collapsed on take-off, and the acft skidded down the rwy and sustained substantial damage, no injuries were reported to the 2 crewmembers, other circumstances are unknown. (-23) on August 6, 1999, at 06:12 Mr.…Accident 19990806010919ACessna T210M · Clovis, NMCargo acft crashed under unknown circumstances, the pilot/sole occupant suffered fatal injuries, the acft was destroyed. (-23) on August 6, 1999, Mr. Pierre a. gasser, airline transport pilot certificate number 2494143, was fatally injured in N6687B, a Cessna…Incident 19990805035389ICessna T310Q · Eagle, CO(-23) Pilot landed at Eagle county airport and experienced left tire failure. Pilot kept aircraft on the confines of the runway and came to rest in the overrun portion of the runway. Only minor damage to aircraft. No injuries. Investigation reveals no further…Incident 19990805030029IBeech 99 · Mineral Point, WI(-23) After landing the pilot tried to apply the brakes. The right hand brake system failed causing the aircraft to go off the end of the runway. The right propeller struck a runway light causing damage to the propeller and engine.Incident 19990805029919IPiper PA28R200 · St. Marys, WI(-23) On 08/05/99, at 0815AM, Piper PA-28R-200, N1179X, dep. Eau claire (eau) on an IFR flight plan to waukesha, WI. During cruise at 5000' the engine began running rough and loosing power approx. 13 miles west of volk ng ap, WI. An emergency was declared and…Incident 19990805027449IBell 407 · New Iberia, LA(-23) Pilot was heading southbound out of New Iberia (ara), when the fadec horn sounded and lights illuminated. Pilot retarded throttle to 90% ng, fadec went into manual mode automatically. Pilot was able to stabilize aircraft and turned back to New Iberia.…Incident 19990805026079ICessna 172RG · Celina, TXPowerplant failure resulted in an off-airport landing with no apparent damage to the aircraft, except within the engine compartment. Inspection of the engine revealed a bent pushrod and associated tube, as well as breakage and detachment of the carburetor…Incident 19990805025949IBeech 1900D · Denver, CO(-23) Pilot landed Beech 1900D, N101UX, flight number GLA6326, on runway 35L. Tower approved turnoff of either high speed turnoff and to contact ground. The pilot replied, left turn mike seven ground. A Beech king air, N91KA, was approaching mike six on…Incident 19990805024449IPiper PA32R300 · Indiana, PA(-23) The aircraft battery was weak when the pilot attempted to start the airplane for a flight to butler, PA. The pilot elected to "jump start" the aircraft and was successful in doing so. When the pilot rotated from the runway and selected the landing gear…Incident 19990805024399IBeech 58 · Jackson, MS(-23) Aircraft was in take off phase when landing gear retracted and aircraft settled on runway.Incident 19990805023699ICessna A185F · Bettles, AK(-23) Incident #AL0199015, 08/05/99, N1931Q, CE-185F; on the takeoff run the aircraft failed to become airborne and the pilot attempted to abort the takeoff. The abort was initiated at a point that did not allow enough pond in which to get stopped. The…Incident 19990805022849ICessna 175B · Tetlin, AKOn August 5, 1999 a tailwheel converted Cessna 175B, piloted by Mr. Danny ray jolliffe, veered off the left side of runway 32 while attempting to land at Tetlin airstrip in Tetlin, Alaska. It was later determined that a bad disk on the right brake caused the…Incident 19990805022509IBeech 58 · Miami, FL(-5)Nose gear collapsed after landing at kopf. Nose gear green lite on through out incident. Retract tube rod end fractured at aft end of rod.Accident 19990805011119APiper PA28140 · Coalinga, CA(Tty) acft crashed during landing. (.19) on August 5, 1999, at 2015 hours pacific daylight time, a Piper PA-28-140, N6814W, lost control during final approach and subsequently veered off the runway at the New Coalinga Municipal Airport, Coalinga, California.…Accident 19990805010839ARobsin R22ALPHA · Shirley, NY1985 Roginson R-22 helicopter was demonstrating a 180 degree rotation when it experienced low RPM and landed hard from 50 feet AGL. (-23)at time and place of occurrence, instructor pilot (hugh paul covopoulo) was demonstrating a 180 degree autorotation…Accident 19990805010829APiper PA28180 · Geneva, WIAcft was taking off when it veered right, struck rwy lights and trees, stalled, and cartwheeled, other circumstances are unknown. (.19) on August 5,1999, at 1415 central daylight time, a Piper PA-28-180, N4337X, piloted by a private pilot, was destroyed…Incident 19990805010819IPiper PA32R301 · Stuart, FLAcft landing on rwy 16 at Stuart, had nose gear collapse and skid on rwy damaging front portion of acft. (-5)on August 05, 1999, during touch and go landing at Stuart airort, martin county, Florida. Pilot stanley e. riker was instructing robert e. downs, who…Incident 19990805010809ICessna 421C · Cincinnati, OHAcft landed gear up at Blue ash airport. (-23) aircraft made a normal approach to rwy 24. Pilot never put the gear down and the plane landed gear up. Pilot had to explanation, just that he did not put it down.Accident 19990805010799ABbavia 8GCBC · Whitewright, TXGroundlooped on landing, damaged wing and prop. (-23) "ground looped" on takeoff. Airman stated that shortly after raising the tail of the aircraft off the ground during the takeoff roll, the aircraft began to yaw to the right. Additionally, the a/c was…