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 20021022031319APiper PA32300 · Bethel, AK(-23) The two airplanes involved in this accident were in motion and taxiing in opposite direction to each other. Both airplanes were taxiing on an uncontrolled ramp. Neither pilot was communicating with ATC or one another. Both pilots failed to exercise…Incident 20021022030119IDorner DO328100 · Pittsburgh, PA(-23) On 10/22/02 at 1732 EDT during an in-flight medical emergency, jetstream airlines flight 4032 struck a rescue vehicle while taxiing to the gate. Minor damage to aircraft wingtip. Flight crew counseled by carrier. Flight crew was receiving improper…Incident 20021022030109ILear 25B · Little Rock, AR(-23) On October 22, 2002, at 0231CDT, LR-25-B, N425JL, diverted from its intended destination due to the left engine losing engine oil pressure (the pilot secured the engine in flight). At nearly the same time the hydraulic system developed a leak not…Incident 20021022029709IBoeing 727224 · Fort Wayne, IN(-23) After landing, the a/c had to stop on the rw. A mechanic brought a pin out for the nose gear before he could taxi in.Incident 20021022029469IMooney M20J · Goshen, IN(-23) Aircraft (N201UF) Mooney M20J landed with the gear still retracted.Incident 20021022029449IAmtr FW190A3 · Columbus, OH(-23) During a normal takeoff from a sod runway, the pilot noticed an uncommon sound from the left main landing gear as though there was some roughness on the surface of the runway. After retracting the gear and leveling off power was adjusted for cruise…Accident 20021022028339ACessna A185F · Waterville, ME(-23) At approximately 1250 hours on October 22, 2002, a Cessna A185F, registration N7321H operated by douglass s. young, was operating within a five mile radius of the Waterville, Maine airport practicing touch and go landings and also testing a newly…Incident 20021022028139IFrchld SA227DC · Billings, MT(-23) After takeoff from Billings, MT (bil) enroute to missoula, MT (mso) the flight crew was unable to establish aircraft pressurization. The flight crew returned the aircraft to bil and landed without incident. Maintenance personnel discovered a split the…Incident 20021022028109ICessna 402B · Billings, MT(-23) Aircraft departed Billings, MT (bil) enroute to great falls, MT (gtf) when the pilot noted a high fuel flow on the right engine. The pilot returned to bil and landed without further incident. Maintenance personnel found a plugged fuel injector.…Incident 20021021036579IAerosp ATR72202 · Bloomington-Nor, IL(-23) On October 21, 2002 during the climb out, about 15 minutes after departure, while on a revenue flight from Bloomington, IL to st. louis, MO, the "electrical smoke" warning light illuminated along with the "master caution" light. The PIC did not declare…Incident 20021021036469ICessna T303 · Fargo, ND(-23) On October 21, 2002, at 0900 local central daylight time (CDT), a Cessna CE-303-T303, N2201C operated by a private pilot, struck a parked fuel truck while taxiing to parking. The incident occurred at Fargo, north dakota, the pilot was not injured. The…Accident 20021021033709ACessna 150M · Kincaid, IL(-23) At approximately 4:34 pm CDT on October 21, 2002 witnesses on the ground observed a Cessna 150 performing low level aerobatics. During one of these maneuvers the aircraft struck the ground in a steep nose low attitude in a farm field near the pilot's…Incident 20021021032879IAmblmp ABCA60 · Valdosta, GA(-23) While attempting to land, wind gust blew into trees.Accident 20021021030399ABbavia 7KCAB · Fort Collins, CO(-23) The aircraft touched down in a 3 point attitude and bounced. The pilot settled the aircraft back down but noticed he was off center line so he added power for a go around but the controls felt mushy, apparently low airspeed. The aircraft drifted to the…Accident 20021021028589APiper PA28161 · Meadview, AZ(.19) On October 21, 2002, about 1645 hours mountain standard time, a Piper PA-28-161, N4332W, collided with a tree during a forced landing at an abandoned airstrip near queen creek, Arizona. The pilot was operating the airplane under the provisions of 14 CFR…Accident 20021021028249ACessna 210C · Riverside, CA(.19) On October 21, 2002, about 1002 pacific daylight time, a Cessna 210C, N9788X, collided with terrain during a forced landing near Riverside, California. The airplane was operated by the pilot/owner under 14 CFR part 91. The commercial rated pilot and one…Accident 20021020038309APiper PA32300 · Plymouth, MI(-23) Pilot landed long on runway with slight cross wind 4 to 6 KTS. Aircraft floated and drifted off runway to right striking vassie control panel with left wing at inboard leading edge of fuel tank. Pilot indicated problems with brakes and aircraft…Incident 20021020036719ICessna 172S · Elizabeth City, NC(-23) The student pilot of the Cessna 172 struck the rudder of the pa 28-181 during taxi. The pa 28-181 was tied down in a parking space at the time of the collision and no one was in the aircraft. The pilot of the Cessna 172 reported that he was unaware that…Accident 20021020031889APiper PA32301 · Paron, AR(-23) On 10/20/2002 at approximately 2:30, a pa 23, N4353Y with six people onboard, impacted the ground in a wooded area approximately 1.5 miles from Paron Arkansas in saline county. No flight plan filed or radio communications were established. The weather…Incident 20021020031859ICessna 172F · Fontana, CA(-23) On Friday October 18, 2002 Mr. Barry rumsey rented a Cessna 172 for a flight to visalia CA. From hanger one aviation a flight school located at riverside airport, riverside CA. On Sunday October 20, 2002, Mr. Rumsey departed visalia airport enroute to…Incident 20021020031639IPerris, CA(-23) 1. Name of jumper: robert m. unzueta, 2. Experience and training of jumper: a. Mr. Unzueta was trained by jim wallace skydiving school Perris Valley Airport, Perris CA. B. Mr. Unzueta started training on October 14, 2000, and had completed 218 voluntary…Accident 20021020030269ACessna 152 · Salisbury, MA(-23) Distribution: original copy ANE-200, NE01 mgr, NE01 spm, NE01 file, AAI200, AFS-300, ACE-100; [privacy data omitted] on October 20, 2002 N47147 a Cessna 152 piloted by Mr. Manuel encarnacion crash-landed in the marsh at Salisbury beach state reservation…Accident 20021020029909ACessna 180F · Wasilla, AK(-23) On October 22, 2002, approximately 1700, the wheel equipped aircraft during a landing at the Wasilla airport, received substantial damage. During the landing roll, the pilot said the airplane swerved to the right and the left wing struck the ground.…Accident 20021020028229APiper PA60601 · Agua Dulce, CA(.19) On October 20, 2002, about 1300 hours pacific daylight time, a Piper Aerostar 601, N700US, collided with terrain after departure from Agua Dulce, California. The airplane was operated by the owner/pilot under 14 CFR part 91. The private rated pilot,…Incident 20021020026969IPiper PA38112 · Grandview, ID(-23) The private pilot and one passenger were on a pleasure flight from boise, Idaho to jerome, Idaho. At a point 35 nautical miles south of boise, Idaho at an altitude of 5,500 feet MSL the engine failed. The pilot initiated an emergency landing to an open…Incident 20021019037409IAmtr RV8 · Vero Beach, FL(-23) No information available from the pilot.Incident 20021019031789IAmtr Searey · Savannah, GA(-23) Night landing. Cleared for approach. Landed with gears up. Damage to belly of fuselage.Accident 20021019031369AAmtr SCORPION* · Opelousas, LA(-23) During landing the pilot experienced a 25 knot gust of wind. The pilot lost control of the helicopter. The helicopter then started spinning. The helicopter impacted the ground hard and rolled on its right hand side causing the main rotor blades to…Incident 20021019030979IBoeing 767222 · Boston, MA(-23) Distribution: original copy ANE-200, NE01 spm, NE01 file, AFS-300, ANE-100. [privacy data omitted] On October 19, 2002 at 0850 EDT a united airlines B-767-222, N607UA struck a flock of birds (cormorants) at 200 feet as it departed runway 22R in Boston.…Incident 20021019030019IBeech 1900D · Little Rock, AR(-23) On October 19, 2002 at 0858 central daylight time a Beechcraft 1900D reported sheet metal peeling off the right engine. The aircraft made an uneventful landing at Little Rock adams field. The airplane was registered to mesa airlines inc. of phoenix…Accident 20021019028919ABell 47G3B1 · Highfalls, GA(-23) Operator said while spraying timber he lost engine power and autorotated into wooded area, iic found that recovery team found only 2 gal. Of gas in left tank. Iic found less then 4 ounces gas/water in right tank. Tank capacity 61.6 gals. 57.5 usable.Incident 20021019028739ICessna 182P · Ogden, UT(-23) Aircraft lost electrical power on return night flight to Ogden, UT. Pilot unsuccessfully attempted to reinstate electrical system, then turned off electrical system to conserve battery but too much power had been used from battery to radio slc approach…Accident 20021019028639ADiamon DA20C1 · Grand Junction, CO(-23) Return night cross country flight from farmington, NM, during approach to land at Grand Junction, CO the aircraft engine started to run rough and sputter. The pilot requested runway 04 at Grand Junction (Walker Field) co. but when it was apparent he…Accident 20021019028629AAmtr Defiant · Denver, CO(-23) Shortly after take off the rear engine started losing oil pressure. The pilot brought the rear engine to idle and started to set up for landing, the Front engine throttle cable broke and the engine went to full uncontrolled power. The piolot forgot to…Accident 20021019028599APiper PA28235 · Van Nuys, CA(.19) On October 19, 2002, about 1025 pacific daylight time, a Piper PA-28-235, N9483W, collided with the ground during a forced landed near Van Nuys, California. The airplane was operated by shane masonry & concrete inc. under 14 CFR part 91. The private…Accident 20021019028579AAmtr ROTORWAY162F · Tucson, AZ(.19) On October 19, 2002, about 1150 mountain standard time, a homebuilt rotorway 162F, N162AZ, landed hard during a forced landing approximately 5 miles south of Ryan field, Tucson, Arizona. The owner/operator was operating the helicopter under the…Incident 20021019028559IPiper PA24250 · Millinocket, ME(-23) At approximately 1 am, shortly after departure from runway 11 at mlt, the entire aircraft electric system failed (including no battery power). The pilot checked circuit breakers and switches to no avail. He could still see the runway lights, so he…Incident 20021018032989ICessna 340A · Atlanta, GA(-23) Right landing gear collapsed on landing. Found uplock push-pull tube broke.Accident 20021018032679ACessna 182B · Somerville, VA(-23) Approximately 1 hour after take off aircraft lost power and impacted ground. Investigation revealed aircraft did not have sufficient fuel in tanks. Pilot received 35 stitches in forehead. Last bfr 03/31/01Incident 20021018032369IAmtr Acrosportii · Zephyrhills, FL(-23) On October 18, 2002, at approximately 1800 EDT, a amateur built experimental acrosport ii, N665BB, registered to Mr. David p. teichman, crashed on landing at Zephyrhills (zph) airport, Zephyrhills, Florida, while on a personal, local flight. Visual…Incident 20021018031069IMooney M20J · Fallbrook, CA(-23) Airman dambkowski was instructing in the Mooney. During a landing, dambkowski inadvertently gave the command "gear up" to airman dalzell. Before dambkowski could react, dalzell had moved the landing gear handle to the up position causing the landing…Incident 20021018030909IPiper PA28236 · Altoona, PA(-23) Follow-up visit to aoo 10-31-02 revealed minor damage to RH wing. Performed engine start and run, engine idle check and low RPM mag check, and fuel selector check, all with no problems. Did not run engine to full power due to configuration of aircraft.…Accident 20021018030449AAmtr RANSS10 · Missouri Valley, IA(-23) Aircraft made a steep approach to landing on runway 34. The aircraft was reported to have made a hard landing, and immediately departed the runway. The aircraft climbed steeply, nosed over, descended vertically and crashed near the runway. Investigation…Accident 20021018028649APiper PA28180 · Salt Lake City, UT(-23) During a flight from mesquite, NV. To bountiful skypark, UT. N33170 experienced loss of power. The pilot requested an immediate landing at Salt Lake City International Airport, runway 35. While maneuvering to land it became apparent that the aircraft…Incident 20021018026929ICessna 210A · Destin, FL(-23) Aircraft main gear failed to extend. Nose gear extended to the down-and-locked position. Pilot attempted to lower the gear several times using both a normal gear system and emergency system. In each case main gear failed to fully extend and pilot was…Accident 20021017033689ACessna 172K · Neenah, WI(-23) On October 17, 2002 at approximately 1630 CDT, the pilot of Cessna 172 N46459 was taxiing for takeoff at 79C rwy 36 when his right wing struck a steel guard pole that protected an above ground fuel tank. These poles are about 8' to 10' tall. The right…Accident 20021017031289ABell 206L1 · Edinburg, TX(.19) On October 17, 2002, at 1600 central daylight time, a Bell 206L-1 helicopter, N303CH, was substantially damaged when it landed hard following a loss of control near Edinburg, Texas. The helicopter was registered to and operated by central helicopters…Accident 20021017030619AHughes 269C1 · Hayward, CA(-23) Aircraft departed (oak) to go to (hwd) to perform 180 degree autorotations at the request of primary instructor. Student had problems managing the airspeed, RPM and keeping the helicopter in trim. Student initiated an 180 degree autorotation. Student…Accident 20021017030589AMaule M7235 · Wrangell, AK(-23) Based on statements made by Mr. Bateham the day after the accident, he took off bound for Wrangell, AK and encountered a fog bank soon after take-off. While in a turn to the left the aircraft hit the water and crashed. Mr. Bateham's foot was caught…Incident 20021017030169ICessna 150M · Littlerock, AR(-23) On October 17, 2002, at 1100CDT, a Cessna CE-150M, N704KT, executed a forced landing on a new/closed/unfinished section of interstate I-440 approximately 10 miles north of little rock, AR. The aircraft's engine stopped when it had consumed all its fuel…