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 20020923029819IDhav DHC8102 · Syracuse, NY(-23) On September 23, 2002, allegheny flight 3848 departed Syracuse-Hancock international airport (syr) when the crew reported #1 engine oil pressure indication went to zero. The engine was shutdown as a precaution and an emergency was declared. The aircraft…Incident 20020923028759IMooney M20M · Renton, WA(-23) During landing pilot contacted ground hard enough to cause aircraft to bounce. Pilot tried to correct by raising flaps. Instead of acuating flaps pilot placed landing gear switch to gear up position causing landing gear to retract.Incident 20020923028509IDorner DO328300 · Boston, MA(-23) Distribution - ANE-200, NE01-SPM, NE01-file [privacy data omitted] delta express 6139 declared an emergency due to fire warning light in the aft cargo area during approach. The fire indication occurred three times before the crew discharged the fire…Incident 20020923027179IBeech 1900D(-23) While enroute from Kansas city Missouri, to dodge city, Kansas on flight 5663, the crew noticed that the cabin door annunciator illuminated at 16,000 ft. the aircraft returned to the field where it was visually inspected for positive latching of the…Accident 20020923026829APiper PA28R200 · Chromo, CO(-23) Aircraft had just been purchased in calif. The day of the accident. After stops in prc and fmn for fuel, the crew was on final leg to apa on V-210, cruising VFR at night at 9,500'. Soon after departing fmn the crew called den ctr requesting flight…Accident 20020923026039APiper PA28140 · Milton, FL(-23) After completing first solo cross-country flight, student pilot performed a touch and go landing at the Milton, FL. Airport (2R4) using runway 36. During the downwind leg the student pilot informed local unicom/traffic advisory that the engine had quit.…Accident 20020923025489AUnivar 1083 · Anacortes, WA(-23) During landing pilot applied brakes causing nose of aircraft to tip toward ground. The propeller struck the ground as the aircraft rolled onto its back. Minor injuries and aircraft destroyed.Incident 20020923025209ICessna 172H · Lincoln, CA(-23) Aircraft was taxiing to fuel pump and hit the left wing tip on a light pole.Incident 20020923024989IDoug DC983 · San Diego, CA(-23) 9/23/02--1239--ON climb out from San Diego, flight encountered a flock of birds. The crew declared an emergency and diverted to los angeles. The landing was uneventful. Post flight inspection determined the radome, the bulkhead behind the radome and the…Accident 20020922037939ADoug DC932 · Minneapolis, MN(-23) On taxi for departure, the right main landing gear collapsed. The upper strut housing cracked which allowed the inner strut to become free. The passengers and crew deplaned using a portable stairs with no injuries.Incident 20020922033199IBeech A36 · Laredo, TX(-23) Nose gear actuator arm part number R-35-825172-13 failed when the landing gear was selected down. Aircraft made an emergency landing at Laredo International Airport. Damage to aircraft consisted of prop, nose gear doors, belly skin and some gear…Incident 20020922028079IAmtr Babybelle · Granbury, TX(-23) "Industrial incident-no intent to fly". On September 22, 2002 owner tom woodward ground ran his experimantal "baby bell" helicopter om jos bacluard/ he stated that this was only an engine run, no intent fly this project. During runup, the aircraft…Incident 20020922026909IBlanca 1419 · Spokane, WA(-23) Pilot stated he was landing on runway 21 at geg, in VFR conditions at 1900 PDT. The visual wing mechanical gear indicators were up on both wings indicating gear down. After touchdown, the left wing slowly began dropping and the wing tip touched the…Incident 20020922026359ICndair CL6002B19 · Memphis, TN(-23) Pinnacle airlines, dba northwest airlink, flagship flight 5963 blocked out at 0628 EDT ktys and departed at 0639. After departure a panel ws found by the taxiway and it was unknown origin. The airline was called it was determined that maybe it was from…Incident 20020922026339IGulstm 690A · Milton, FL(-23) Pilot stated that he did not put the gear down. The aircraft skid about 750 feet. Minor damage to the belly of the aircraft. No injuries.Incident 20020922025269IAmtr Heathparasol · Post Falls, ID(-23) Pilot made a successful precautionary landing in a farm field due to tough running engine. Pilot determined problem may have been carburetor ice. Ground power check was good and pilot decided to continue his flight. There were about 20 horses in this…Accident 20020922024869ACessna 172H · Weed, CA(-23) Aircraft was being hand propped when it got away from the pilot, took off without anyone on board, flew away from the airport and crashed on a highway. (.19) on September 22, 2002, about 0625 pacific daylight time, a Cessna 172H, N2469L, impacted the…Accident 20020922024469AAmtr RANSS12XL · Bluff, UT(-23) Aircraft was observed flying up the center of a steep walled canyon approximately 400 feet below the rim. And 200 to 300 feet above the canyon floor aircraft attempted to turn around, nose raised, left wing abruptly lowered and ballistic emergency…Incident 20020921035279ICessna 560CESSNA · Chicago, IL(-23) The aircraft was cleared for takeoff on runway 31C. The pilot taxied slightly left of the assumed centerline lighting position, and held there while the cabin was checked. Brakes were held as power was increased to takeoff power. Brakes were released…Incident 20020921032529IAmtr LANCAIR235 · Suffolk, VA(-23) Nose gear collapsed while the aircraft was taxiing in after landing. Overcenter mechanism failed to hold the nose gear in the down and locked position. Builder will send m&d with cause.Incident 20020921032509IAmrgen AA5B · Bellfonte, PA(-23) N28665 departed unv on an IFR flight plan with a destination of thv. Approximately 15 minutes after takeoff, the pilot stated that the engine was running rough. The engine roughness increased and then #3 cylinder blew off the engine. The pilot declared…Accident 20020921031259ACessna 172N · Bumpas, VA(-23) On September 21, 2002, at about 1330 eastern daylight time, a Cessna 172, N737TG, was substantially damaged while landing at Lake Anna Airport (7W4), Bumpas, Virginia. The private pilot, charles joesten, was not injured. The flight was conducted under…Accident 20020921030609APiper PA32RT300 · Brunswick, GA(-23) While aircraft was conducting a power-off approach (accuracy landing) the aircraft lost altitude and struck an oak tree on adjacent property and impacted the ground on airport property approximately 60 feet before the end of runway. Aircraft broke apart…Incident 20020921029589IMooney M20C · Lafayette, IN(-23) On 09/21/02 a Mooney, M-20-C, registration number N6231U, shortly after departure from laf, while in cruise at 3,000 ft at approximately 1633Z, pilot heard a loud pop from the engine area. Smoke came from the front cowling, then into the cockpit. Pilot…Incident 20020921029319IAmtr XP503 · Pembroke Pines, FL(-23) Aircraft lost power during approach to north perry airport (hwo), made an emergency landing on a golf course. One wing clipped a palm tree and aircraft slid into a canal. One person on board, no injuries. Minor damage to aircraft.Incident 20020921029089IGulstm G73 · Ft Lauderdale, FL(-23) Flying boat inc. flight 501 was on a flight from pid (paradise island-bahamas) to fll (ft. Lauderdale, Florida) when the crew noticed hydraulic quantity decreasing. On approach to fll crew followed emergency gear extension procedures, verified gear down…Accident 20020921028269ACessna R172K · Challis, ID(-23) Pilot was landing on back country private airstrip (flying b) and veered to the left striking fence posts and irrigation pipes. Damage to propeller, left landing and tail section. No injuries. End of report.Incident 20020921027979ICessna 177RG · Columbia, IL(-23) On approach to cps, pilot noticed the nose gear would not extend. Pilot attempted to jar the nose gear loose to no avail. He elected to return to sackman field, Columbia, IL and land with all landing gear retracted. Made a gear-up landing at sackman.…Accident 20020921026479ACessna 182L · Mc Call, ID(-23) Pilot was side stepping to land on taxi-way due to close runway. Pilot under shot taxiway and came to rest in a ditch between runway and taxiway. Pilot exited aircraft safety. No injuries. Post landing fire destroyed aircraft. End of report.Accident 20020921026399AAmtr Hornet · Archdale, NC(-23) Pilot departed runway 21 and realized that the right door (passenger door) was open. Pilot made decision to return to airport to secure door. The aircraft was turned, flaps lowered, and airspeed reduced to landing speed. The pilot realized he was lined…Accident 20020921026249AChris A1 · Cherry Point, NC(-23) Aircraft departed mqi as number four aircraft in a flight of four. Flight was from mqi to nkt. Upon arrival at nkt, N6QR was number four for landing. The other three aircraft landed without incident and N6QR was cleared to land. The pilot flared…Accident 20020921025939ABag B2062 · Mcalpin, FL(.19) On September 21, 2002, about 1150 eastern daylight time, a beagle aircraft, B-206 series 2, N86GW, registered to smm, inc., operating as a title 14 CFR part 91 personal flight, crashed in the vicinity of Mcalpin, Florida. Visual meteorological…Incident 20020921025839IAmtr Merlingt · Arlington, WA(-23) Aircraft was landing on rwy 34 at awo. Aircraft caught wind and hit runway light causing aircraft to ground loop. Left wheel came off, left wing tip struck ground then landing gear folded. No injuries.Accident 20020921025249ABeech V35 · Del Rio, TX(.19) On September 21, 2002, at 1655 central daylight time, a Beech V35 airplane, N9486S, was substantially damaged when it impacted a fence and a ditch during a forced landing following a loss of engine power during takeoff at the Del Rio International…Accident 20020921025049ACessna 172RG · Carlsbad, CA(.19) On September 21, 2002, about 1445 pacific daylight time, a Cessna 172RG, N6303V, made an off airport forced landing following a loss of engine power near del mar, California. Air charter express, inc., was operating the airplane under the provisions of…Accident 20020921024979ASZD SZD422JANTAR · Hemet, CA(.19) On September 21, 2002, about 1330 pacific daylight time, an experimental pzl-bielsko Szd-42-2 jantar glider, N131AS, collided with terrain under unknown circumstances near Hemet, California. The private pilot/owner was operating the glider under the…Incident 20020921024959IAmrgen AA5B · Salinas, CA(-23) N45315 Grumman AA-5B lost power in flight and made a forced landing 5 miles southeast of Salinas CA airport at approximately 15:30 local time on September 21, 2002. The sole occupant was not hurt and N45315 received minor damage. Engine power loss…Accident 20020921024479ACessna 172S · Boyne Falls, MI(-23) Pilot landed hard on rwy 35 at Boyne Falls, MI. (Kbfa). Phone call on 9-24-02 with pilot confirmed the hard landing and maint. Inspector miller of the grr-fsdo looked at aircraft and confirmed damage at the tulip city airport in holland, MI. On 09-24-02.Incident 20020920030359IPiper PA23150 · Kapolei, HI(-23) The pilot in command/flight instructor stated that on the 3rd single-engine landing, with all check lists completed and gear lights verified, the aircraft touched down without the gear being extended. After the aircraft was returned to the FBO a landing…Incident 20020920029079IPiper PA38112 · Pensacola, FL(-23) Mr. Farfan stated: on sep 20, 2002 he was flying his first solo after completing a check ride with an instructor prior to the mishap. He was not taking any medication, nor was the weather a factor which could have contributed to the incident. While…Incident 20020920028529IConaer LA4200 · Northwood, NH(-23) While conducting a water takeoff, the pilot did not assess properly the current density altitude, the pilot did not allow sufficient takeoff distance, in the takeoff climb the aircraft struck a conifer type tree on the left wing leading edge, only…Incident 20020920027849IBeech 76 · Fort Worth, TX(-23) On September 20, 2002, airman walter mercer was acting as a certificated flight instructor (multi-engine) giving william sims multi-engine instruction in aircraft N6015Q, a Beechcraft duchess. Upon landing at Spinks airport, Mr. Mercer inadvertently…Incident 20020920027299IBeech 1900D · AR(-23) While flight 5431 was enroute to new orleans, Louisiana, the cargo door illuminated 60 miles outside of new orleans. The aircraft continued to new orleans, Louisiana with no further incident.Accident 20020920026519AMooney M20R · Burnsville, NC(-23) The pilot performed a fly-by to check runway conditions. She circled around and did a long, low approach with gear down. As aircraft approached runway, the aircraft appeared to veer up and to the left. Witnesses stated aircraft stalled and they heard an…Incident 20020920026309ICessna 172M · Sumter, SC(-23) Student pilot on second solo was attempting to land on rwy 23 at Sumter airport SC, on roll out the aircraft lost directional control and departed the runway, crossed the taxiway and came to rest in a ditch parallel to the runway. No injuries or fire.…Incident 20020920025799IFrchld PT19A · Waldoboro, MN(-23) On 09-20-2002, at approximately 1100 hrs. The pilot of N54804, departed the laconia, new hampshire (lci) airport enroute to the rockland, Maine airport (rkd). The pilot stated that while at the laconia, NH airport he had 24 gallons of fuel added to the…Accident 20020920024539ADhav DHC2MK1 · Bethel, AK(-23) According to the pilot, after takeoff the aircraft got to an altitude of 50 feet, stalled and crashed. The pilot stated that before beginning the flight, he did not remove the frost from the aircraft.Incident 20020919030009IBeech 200BEECH · Fayetteville, AR(-23) N1194C, BE-200 inbound to Fayetteville experienced unsafe gear indication prior to landing. Nose gear collapsed on rollout 1433 CDT on September 19, 2002. No injury to pilots or 6 paxs. Pilot put landing gear in the down position. As gear was extending…Accident 20020919028279AAmtr PW5GLIDER · Loch Lomond, CA(-23) Pilot was attempting to land. Pilot misjudged altitude, stalled and spun in. (Information was determined with the help of a pilot examiner who was familiar with the GPS which was on board the aircraft). Pilot was seriously injured, aircraft was…Incident 20020919026179IPiper PA28180 · Louisburg, NC(-23) Approach to lhz blade separated from propeller. Aircraft landed safely.