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 19990611018289IBeech M35 · Seattle, WA(-5)The pilot stated to an FAA airworthiness inspector, that after the landing the aircraft onto runway 31R and during the rollout, he inadvertently placed the gear handle switch in the up position instead of selecting the flap switch to the up position. The…Accident 19990611017289APiper PA18150 · Baudette, MN(.19) On June 11, 1999, at approximately 0812 central daylight time (all times CDT), a Piper PA-18-150, N305NR, operated by the Minnesota department of natural resources (dnr), was destroyed when the airplane impacted the ground about 22 miles south of…Incident 19990611014089IPiper PA46310P · Syracuse, NYOn Friday, June 11, 1999 at 1432 local, a Piper 1432 local, a Piper malibu,N26033, owned and operated by ram fabricating, inc. under CFR part 91, returned to Syracuse international airport after reporting a loss of engine power. The flight crew, after…Accident 19990611007079ACessna 172N · Grand Junction, COAcft landed on the nose gear, and the gear buckled into the firewall, other circumstances are unknown. (-23) on June 11, 1999 at 1000 mountain daylight time, a Cessna 172N, N359DS, sustained substantial damage during a reported hard landing at Walker Field,…Accident 19990611007029ARobsin R44 · Sevierville, TN199 Robinson R-44 helicopter experienced main rotor and tail rotor failures in flight and sustained substantial damage, other circumstances are unknown. (From .19) on June 11, 1999, about 1715 eastern daylight time, a Robinson R-44, N49669, registered to…Incident 19990611006979IBlanca 14193 · Mattawa, WAAcft brakes locked up on landing, and the acft ran off the rwy and went into the sagebrush. (-23) pilot unable to judge height above the ground within 10 feet. Referred to medical evaluation resulting in cataract surgery. [privacy data omitted]Accident 19990611006939AScwzer G164B · Goodland, KSAcft rocker-arm pin broke, and the engine quit, the acft landed on a road, but the left wing caught in some wheat and spun the acft around, other circumstances are unknown. (.19)on June 11, 1999, at 1630 cnetral daylight time (CDT), a Grumman American G-164B,…Accident 19990611006859APiper PA18150 · Goose Bay, AKAcft crashed on take-off and sustained substantial damage, other circumstances are unknown. (From .19) on June 11, 1999, about 1530 Alaska daylight time, a short takeoff and landing (stol) equipped Piper PA-18 airplane, N2668P, sustained substantial damage…Accident 19990610045579AScwzer SGU222E · Hobbs, NM(-23)On June 10, 1999, at 1520MST, a Schweizer SGU-2-22E, registration number: N5823V, registered to the civil air patrol, while on a solo training flight from Hobbs air park, Hobbs, NM., a student pilot was performing steep turns at 1000 feet. As the pilot…Accident 19990610036909ACessna 172N · Houston, TX(.4) On June 10, 1999, at 1850 central daylight time, a Cessna 172N single engine airplane, N5103D, sustained substantial damage when it exited runway 17R during the takeoff roll at the David Wayne Hooks airport, spring, Texas. The airplane was owned by a b…Incident 19990610027089IMtsbsi MU2B35 · Seminole, OKThe crew failed to lower landing gear. The PIC thought he saw green lights during final check.Incident 19990610024519ICessna 172RG · Seattle, WAAircraft departed pae on an instructional flt. Enroute to bfi, pilot reported that NLG would not extend. Various attempts were made to extend gear. Aircraft executed a flyby of the bfi tower and NLG was verified as retracted. Aircraft landed on rwy 31L. Prop…Incident 19990610022769IN96062 · Roscommon, MITailwheel airplane, braked too hard during landing rollout, aircraft tipped up and struck prop, no other damage.Incident 19990610022099ICessna 320B · Saint George, UTOn June 10th, 1999 at 1110 am MDT, Mr. Dan howard landed his Cessna 320B, N9840L, at the st. George airport (sgu). Mr howard reported the landing as normal. During the landing roll-out the aircraft experienced a severe shimmy in the nose gear. Shortly after…Incident 19990610018689IGulstm 112 · New Orleans, LA(-5)Pilot claims no other reason for incident other than he forgot to lower the landing gear.Incident 19990610014019ICessna 172M · Saratoga Spring, NYPilot hand propped the aircraft engine to get it started. The engine started and accelerated, the pilot lost control of the aircraft and it taxied into near by hanger. [privacy data omitted]Accident 19990610007919ABell 47G3B2A · Pendleton, OR1972 Bell BH-47-G3B2A helicopter was performing aerial application operations with a bucket attached when the lines became caught in ground equipment, and the acft struck the ground and sustained substantial damage, other circumstances are unknown. (-23)pilot…Accident 19990610006969AAmtr Varieze · Odessa, MOAcft landed hard, and the landing gear collapse, other circumstances are unknown. (-23)the airplane "dropped in" as the pilot was landing. Inspection of the aircraft revealed substantial damage. The nose and main gear assemblies collapsed causing damage to…Incident 19990610006759ISwftms GC1B · Fort Smith, ARAcft lost power on final approach and landed short of rwy 25, other circumstances are unknown. (-23) on June 10, 1999, at 1750 CST, a single engine aircraft, globe switf, model GC-1B, N87104, operated by homer g. ellis, pilot in command, landed about 1800…Accident 19990610006749ACessna 182P · West Palm Beach, FLPilot was practicing touch and go landings and the acft lost power, the pilot decided the acft would not make it to the arpt and made an emergency landing off-field, other circumstances are unknown. (-23) on takeoff the aircraft lost power in the downwind leg…Accident 19990609045549ABell 412 · Patterson, LA(-23)The tail rotor and tail rotor assembly separated from the aircraft during flight over the gulf of Mexico after a tail rotor blade failed. The flight crew executed a successful autorotation and landed on the water with the aircraft's emergency floats…Accident 19990609043209ACessna 172N · Weaverville, CA(-23) Pilot attempted a low pass over runway 36 at the Weaverville airport, he did not intend to land and came within 15 feet above the runway. The a/c suddenly struck the ground approx. 1/3 to 1/2 down the runway. Pilot began a go around and due to rapidly…Accident 19990609041989ABoeing 747422 · Pacific Ocean(-23) Approximately 30 miles west of niket intersection R471, copilot was advised by flight attendant of an accident causing serious injury to f/a [privacy data omitted] a[privacy data omitted]answered the summons for medical assistance and after evaluation…Accident 19990609036859APiper PA28181 · Auburn, AL(-23) Aircraft N983DB departed lakeland, FL on 06/09/99. Aircraft made one stop in valdosta, ga and then continued on to Auburn/Opelika, AL, approximately 15 miles south of Auburn/Opelika airport the pilot reported engine trouble and that he may be out of…Incident 19990609029939IFokker F28MK0100 · Sioux Falls, SD(-23) While N1460A was enroute from msp to dfw, flight attendant advised cockpit crew that something was burning in the galley, smoke and source could not be identified. An emergency was declared and aircraft diverted to fsd. Prior to landing, smoke…Accident 19990609024059APiper PA24250 · Plentywood, MT(.19) On June 9, 1999, at 1158 mountain daylight time, a Piper PA-24-250 airplane, N5309P, was substantially damaged during landing on runway 16 at Plentywood, Montana. The private pilot-in-command and one passenger were not injured in the accident. The pilot…Accident 19990609021759APiper PA28R200 · Cape Canaveral, FLOn June 9, 1999, about 2054 eastern daylight time, a Piper PA-28R-200, N56192, registered to major strategies, inc., was lost from radar and radio contact approx. 354 degrees and 2.2 nautical miles from the Cape Canaveral air force station skid strip, Cape…Incident 19990609018759ICessna 182Q · Oxford, FL(-5)Fast taxiing on ruwnay to check fuel flow in right tank. Reduced power. Midway runway pulled all power shortly after. Brakes did not stop plane. Rolled off end of runway.Incident 19990609015219IBag JETSTM3201 · Lexington, KYTire blow out at touchdown. Crew maintained directional control with brakes and nose tiller.Incident 19990609014679ICessna 150F · Manhattan, KSWilliam perry, a student pilot, experienced an upset and flipover of his Cessna 150 while taxiing on the ramp of the Manhattan, KS airport due to gusty winds from a nearby thunderstorm. The damage to the aircraft was minor in nature and the pilot was not…Accident 19990609006739ACessna 182D · Zurich, KSPilot made an emergency landing in a wheat field due to the formation of carb ice and subsequent engine failure, and the acft flipped over on landing, other circumstances are unknown. (.19)on June 9, 1999, at 1130 central daylight time, a Cessna 182D, N9169X,…Accident 19990609006699ABell 206B · JuneauAir helicopters air taxi (1969 Bell 206B helicopter) rolled over on take-off, struck the tail rotor on the ground, and the acft broke up and was destroyed, the 2 POB sustained minor injuries, other circumstances are unknown. (.4)the on-demand air taxi pilot…Accident 19990609006689ASnias AS350BA · Juneau, AKCoastal helicopters air taxi (1994 Eurocopter AS350BA helicopter) crashed under unknown circumstances into herbert glacier while on a sight-seeing flight, the pilot and 6 pax all suffered fatal injuries, the acft has substantial damage, other circumstances…Incident 19990608038069IPiper PA34200 · Daytona Beach, FL(-23) The nosegear failed due to excess play in over center linkage. The excess play was from a bent clevis bolt which installs through the downlock link assembly and the over-center linkage.Incident 19990608034549IPiper PA28201T · Santa Barbara, CA(-23) On June 8, 1999, pilot david ethan miller, certificate number 2346913, was flying N8088Z from vny CA to lpc CA. At san marcos VOR the pilot noticed that he was loosing manifold pressure. He informed sba control tower and diverted to sba. The pilot then…Incident 19990608033639ITmpson NAVION* · Three Lakes, WI(-23) On June 8, 1999, at approximately 1145 CST, a navion NA1, N4264K, registered to and operated for pleasure by Mr. Oliver boyd clow, stalled while landing on runway 21 at Three Lakes, WI, (40D). Visual meteorological conditions prevailed at the time and…Incident 19990608022589IMtsbsi MU2B60 · Cincinnati, OH(-5)During landing of this MU-2B aircraft, pilot failed to place landing gear handle in the down position thus landing with the landing gear in the up position.Accident 19990608021959ACessna 180J · Palmer, AKOn June 8, 1999, about 1700 Alaska daylight time, a float equipped Cessna 180J airplane, N7560K, sustained substantial damage during landing on Wolf lake, Palmer, Alaska. The airline transport pilot and sole passenger were not injured. The flight was being…Accident 19990608021729ACessna 402C · Ft Lauderdale, FLOn June 8, 1999, about 1526 eastern daylight time, a Cessna 402C, N440AB, registered to tropical international airlines, inc., and operated by air sunshine, inc., as a title 14 CFR part 135 non-scheduled international passenger flight, public charter, from…Incident 19990608018869IPiper PA28R201T · New Orleans, LA(-5)After initial contact with the ground, the aircraft slide on the runway approximately 700FT, coming to rest at or about the 3000 ft mark. The pilot failed to lower the landing gear during the "gumps" check.Accident 19990608006659AHughes 369D · South Bend, WA1978 Hughes 369D helicopter was involved in an external load operation when the acft engine failed, the pilot autorotated the acft, and the acft made a hard landing and sustained substantial damage, other circumstances are unknown. (-23) helicopter released…Accident 19990608006649ACessna 140 · Woodstock, GAAcft engine quit on take-off, and the acft crashed into some trees, other circumstances are unknown. (-23)aircraft accelerated normally on take off. At about 200 ft. alt. Engine sputtered pilot states he pumped throttle several times and then ckd. Mixture,…Accident 19990608006639AWSK M18DROMADER · Dumas, ARAcft crashed into a rice field shortly after take-off and struck a levee, other circumstances are unknown. (-23)on June 08, 1999 at approximately 1130 am a Wsk-pzl, model M-18, N52401, piloted by [privacy data omitted] made an emergency landing after takeoff…Accident 19990608006629AAmrgen AA5A · De Motte, INAcft landed long and ran off the end of the rwy. (.4) the private pilot conducted a local flight. On landing he allowed the airplane to touch down approximately 1,000 feet down the 2,600 foot runway. He was unable to stop the airplane on the remaining runway…Accident 19990608006619ASnias AS350B · Ashcamp, KYAerospatiale AD-350B helicopter dropped of passengers at a work site and was taking off when it struck a power line, the acft crashed and was destroyed, the pilot/sole occupant suffered fatal injuries, other circumstances are unknown. (.4)after dropping off…Accident 19990608006609ACessna 340A · Phillipsburg, KSPilot reported an acft fuel flow problem, the controller provided arpt information, the pilot overflew the arpt, the controller informed the pilot of the acft position from the arpt, the pilot then reported the arpt in sight and was issued a visual approach,…Accident 19990607044979APiper PA28140 · Traer, IA(Tty)aircraft did not gain enough speed on take-off and was attempting to abort the take-off when it slid off the rwy and struck a pile of dirt, other circumstances are unknown. (-23)the pilot stated the runway was very rough and during takeoff the aircraft…Incident 19990607024259ICessna T210M · Laredo, TXPilot stated airport had numerous jets in his traffic pattern area and was distracted in his attempts to locate possible conflicting aircraft. Pilot admits to forgetting to put the gear down. Aircraft sustained minor undercarriage and prop damage. Will…Accident 19990607023849AHughes 369HS(.19) On June 7, 1999, at 0900 hours local time, a Hughes 369HS, N4278M, crashed into the pacific ocean following separation of the tail rotor gear box approximately 300 miles southwest of majuro in the marshall islands. The helicopter, owned and operated by…Incident 19990607016729ICessna 310L · Prescott, AZOn June 7, 1999, @ 12:35 p.m. (MST), Cessna 310L, N3286X, landed on rwy 21L at Prescott (prc) airport, Arizona. During roll out, the right main landing side brace experience catastrophic failure, resulting in the collapse of the right main landing gear. The…