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 20090402046879ACessna 180K · Iniakuk Lake, AKNTSB# ANC09CA027 ptrs# AL01200902135PILOT landed on Iniakuk Lake which was snow coverd with drifts. The aircraft impacted a drift which took the skis off the gear and bent the left landing gear aft.Accident 20090402008849APiper PA31325 · Newark, NJ(-23) Pilot stated that he aborted his first takeoff attempt on rwy 22R at kewr because he could not maintain directional control. When askeed if the reason he lost directional control was due to brake failure he said yes. Pilot stated that he pulled off the…Incident 20090402004679IPiper PA18150 · Fort Myers, FL(-23) On 02 April, 2009, at 10/421 EDT, a Piper PA-18-150, N18LP, serial number 18-5501, operated by [privacy data omitted] was giving flight instruction to [privacy data omitted], ground looped on landing at Fort Myers Page Field (fmy). The aircraft received…Accident 20090402004579ACessna 337G · Barstow, CA(-23) CE-337 with two persons on board experienced a failure of both engines. Pilot was forced to land on a gravel road with strong, gusty surface winds, resulting in substantial damage to the aircraft.Incident 20090401046859ICessna 208B · Bethel, AKThe pilot [privacy data omitted] departed scammon bay at approximately 1400 enroute to Bethel, AK. Two souls onboard, the pilot [privacy data omitted] and a ride along [privacy data omitted] (new hire pilot). Crusing at 7500 about 39 miles out of chevak…Incident 20090401010289IBoeing 767322 · Bangor, ME(-23) This office was notified by the new england region operations center that: "united 923, B767/H heathrow to dulles diverted to Bangor, ME landing without incident runway 33 at 0942 EDT, 4/1/09 after shutting down #1 engine and smoke in the cockpit, "this…Accident 20090401004419AMaule M4220C · Hungry Horse, MT(-23) On April 1, 2009, about 1630 mountain daylight time, a Maule M4-220C, N2007U, impacted the frozen surface of a reservoir near Hungry Horse, Montana, killing the sole occupant, a private pilot. The aircraft was destroyed. Lockheed martin flight service…Accident 20090401003309APiper PA22150 · Sherwood, OR(-23) Aircraft departed private lasardi air strip (4OR7) north of salem, OR, April 1, 2009, at approximately 0711 hours, for a direct flight to hillsboro, OR (hio) with 2 persons on board. Both occupants were certificated private pilots, single engine land,…Incident 20090331010829IPiper PA28R200 · Oxford, CT(-23) Aircraft N2321T, a Piper PA-28R-200 experienced a hard landing that resulted in minor damage to the top sheetmetal surface of the left wing. The damage to the left wing included numerous small cracks aft of the fuel tank and above the landing gear…Incident 20090331010819IJacklb MARQUARTM5 · Williamstown, NJ(-23) Aircraft departed sothern cross airport (CO1), at approximately 1450 local heading east towards vineland-downstown airport (28N). Ten minutes into the flight he noticed engine power loss. An emergency landing was performed on a farm field located at…Accident 20090331005559ABeech A36 · Batavia, NY(-23) On 3/31/2009 at approx 1500 hrs, [privacy data omitted] departed gvq airport. After a half hour flight he attempted a landing at a private grass strip which his family ownes, located at [privacy data omitted] he described to this inspector a normal…Incident 20090331005549ICessna 172R · Danbury, CT(-23) Danbury tower cleared N9715F to land on runway 35. After landing the aircraft veered to the left off of the runway surface. The aircaft's propeller then contacted an elevated taxiway light. On-scene investigation revealed damage to the propeller and the…Incident 20090331004809IMooney M20F · Portland, OR(-23) [privacy data omitted] was doing night recurrency landings at airport, Troutdale, Oregon (ttd). First landing while flare he noticed unusual noise from nose gear area. He aborted landing and went around. On fly by tower reported gear not down. Aircraft…Incident 20090331004789IDhav DHC8311 · Allentown, PAAircraft left propeller struck a redtail hawk during landing rollout. Aircraft taxied to gate without incident. Inspection revealed one propeller blade damaged. Propeller blade replaced by maintenance and aircraft returned to service.Incident 20090330008329ILear 55 · Chicago/Aurora, IL(-23) Aircraft left main tires caught fire following numerous high energy stops for maintenance purposes. The aircraft sustained minor damage, fire was contained to the tires and surrounding area. A company pilot and mechanic were onboard with no injuries…Incident 20090330005499IPiper PA28R200 · Tallahassee, FL(-23) On March 30, 2009 at approximately 1630 EDT a Piper PA-28R-200, N3921X, register to [privacy data omitted] had a propeller strike with an orange safety cone while taxiing at Tallahassee Regional Airport in Tallahassee, FL. The pilot of the airplane was…Accident 20090330004729ARobsin R22 · Chandler, AZ(-23) A flight instructor with low experience (4 months) was conducting an "introductory" flight with a possible future student. The CFI was allowing the passenger to handle one control at a time while he kept overall control of the helicopter. While the…Accident 20090330004029ARogers Flaglorscoot · Griffin, GA(-23) The pilot departed runway 33 at Beaverbrook Aerodrome(10GA) and at approximately 150 foot above ground level the engine began to sputter and miss. [privacy data omitted] Turned approximately 60 degrees to the right to avoid obstacles and have an open…Incident 20090330003649IDoug DC983 · Omaha, NE(-23) N931TW - DC-9-83, was operated by American airlines as flight 1708, enroute from las to ord. The crew declared an emergency and diverted to oma due to a pressurzation problem. The crew reported that at FL250 upon entering weather the left pack failed.…Incident 20090330002659IDoug MD9030 · Salt Lake City, UT(-23) Delta airlines MD-90 aircraft, registration number N901DA, flight number 1220 scheduled to operate from Salt Lake City, Utah, (slc) to santa ana, California, (sna) on 03/30/2009, sustained minor damage to the forward left passenger entry door when the…Incident 20090330002279ICndair CL6002B19 · Denver, CO(-23) Aircraft N906SW flight number 6695 departed Denver International Airport, Denver, Colorado, and experienced smoke in the flight deck and cabin during ascent. The flight crew followed the qrh, donned oxygen masks and requested to return to Denver…Incident 20090329012129IBell 407 · Offshore Gomex(-23) Pilot in command made a day, VFR approach to an Offshore oil platform with 3 passengers on board and made his approach to the platform into the wind. Pilot stated he executed his approach to the platform so as to land slightly right of center and with…Incident 20090329006549IBeech D35 · Lancaster, TX(-23) At approximately 1500 CST on 03/29/2009, [privacy data omitted], a commercial pilot, was involved in an incident at Lancaster municipal airport, TX, (klnc). [privacy data omitted] Was conducting touch and go's in a Beech bonanza D35, N3407B, sn D-3645,…Incident 20090329005469IAmtr Velocity · Taylor, TX(-23) Engine lost power during climb after takeoff. Airplane landed in a field with damage to landing gear.Accident 20090329005279ASiaima SM1019B · Dade City, FL(-23) On March 29, 2009, at around 1100 am local, near Dade City, Florida, aircraft N273LH, an experimental amateur built marchetti, model SM-1019B, while on take off, struck a tree limb, spun and impacted the ground. The pilot [privacy data omitted],…Accident 20090329005059ACessna 150L · Brunswick, GA(-23) The student pilot was solo in the pattern for runway 22. The winds increased from 260 degrees at 14 knots gusting to 18 knots. The student landed hard which resulted in the airplane porpoising (reference FAA-H-8083-3A page 8-31). The nose gear sheared…Accident 20090329004989ACessna P210N · Georgetown, TX(-23) Engine lost power on approach to landing. Pilot had fuel selected on low level left fuel tank. Engine lost power on final approach. Pilot said he could not hear engine quit due to wearing headsets. Lost altitude, switched to full fuel tank, and was…Accident 20090329004109ACessna 550 · Salt Lake City, UT(-23) On March 29, 2009 at 1630 local time, [privacy data omitted] (PIC) and [privacy data omitted] (SIC) landed N44FR, a Cessna 550, at the Salt Lake City International Airport. During the landing rollout, the right hand main gear began an uncommanded…Incident 20090329003129IEastma GS2SPORTSMAN · Apple Valley, CA(-23) While landing on runway 18, the aircraft was ground looped. Winds were reported 24022G30, but pilot reported actual wind direction was variable. Pilot originally attempted to land rwy 26: however, actual wind was favoring runway 18. Upon touchdown on…Incident 20090329003029IBell 206L3 · Abilene, TXOn March 29, 2009 at 1240 CDT, bh 206 L-3, N708M, operated by evac, accepted an air medical mission from hendrick hospital, in Abilene to university medical center (umc) in lubbock, Texas arriving at 1356 CDT. The flight was uneventful. The crew departed umc…Accident 20090328007969ADoug MD88 · Atlanta, GA(-23) On March 28, 2009 delta flight 1966 departed el paso, TX for Atlanta, GA. As the flight started its descent on the honie arrival the crew observed rain showers on the radar. Captain [privacy data omitted] and first officer [privacy data omitted]…Accident 20090328005819AAmtr LANCAIR320 · Milton, FL(-23) On March 28, 2009, at Peter Prince airport (2R4), in Milton, FL. Pilot attempted to land with gusty winds on runway 18. Witness stated that during landing the aircraft bounced several times before the right wing made contact with the ground causing the…Incident 20090328004849INamer AT6D · Destin, FLPilot in command failed to maintain control of the aircraft in gusty crosswind conditions. Wind gust lifted right wind during landing rollout causing uncommanded swerve to the right. Aircraft departed the runway into adjacent grass area. Left main mount…Accident 20090328004709APiper PA28235 · San Carlos, CA(-23) On March 28, 2009, at approximately 1050 hours local time, N9249W, a Piper PA-28-235 departed San Carlos Airport (sql) on a pleasure flight. The aircraft departed runway 12 and after climbing to an altitude of about 100 to 150 feet, the pilot reported…Accident 20090328004119AAviat A1B · Cedar City, UT(-23) On March 28,2009 at 1400 local time [privacy data omitted] was landing N665AM, an Aviat husky A1-B, on a private strip approximately 40 miles west of Cedar City, UT. During the landing rollout, the right wing of the aircraft was lifted by a gust of wind…Accident 20090328003869ACessna T210L · Madera, CA(-23) The aircraft departed runway 30 at mae from what appears to be a "touch and go" landing according to a witness statement. The aircraft may also have been returning to mae, home base for the aircraft, from a cross country flight. The aircraft was…Incident 20090328003179ICessna 310J · Reedley, CA(-23)This situation was brought to the faa's attention through an anonymous call regarding this aircraft which experienced a main gear collapse after landing and may request a ferry permit. Contact was made with the airport manager who admitted to the failure…Incident 20090327005609IPiper PA24250 · Chicago/Rockfo, IL(-23) Pilot was executing touch and goes for the purpose of staying current. Runway 1 was closed at 1630 local. Pilot was cleared for takeoff on runway 7 and completed touch and go on runway 7. Then tower switched runways to runway 1 which favored the wind.…Incident 20090327005389IPiper PA23 · Elizabethtown, KY(-23) Due to weather conditions aircraft was unable to maintain altitude. Once deviation occurred pilot descended immediately back to assigned altitude.Incident 20090327005139IManda Mkii · Riverside, CA(-23) While landing on runway 9, a 30 wind gust caused the aircraft to veer left off the runway. Both main landing gear wheel fairings were damaged. Aircraft was pushed back on the runway and taxied to parking spot.Accident 20090327004089ACessna 182Q · Sedona, AZ(-23) On 03/27/09 the pilot landed on ruwnay 21 at Sedona Airport, on touchdown the pilot lost control of the aircraft and went off the end of the ruwnay. As the aircraft went through the fence, located at the end of the runway, the aircraft flipped over and…Accident 20090327003299ACessna 180G · Wendover, UT(-23) On March 27, 2009 at 1545 local time, [privacy data omitted] was conducting touch and go landings in N98FC at the Wendover, UT airport. During the rollout on his second landing, the aircraft began to pull to the right. [privacy data omitted] Applied…Incident 20090327002289IDoug MD88 · Everett, WA(-23) On climb out the lavatory smoke detectors were heard by the crew. Landed at pae and found the APU starter driver o-ring bad.Accident 20090326046829ACessna 170B · Dillingham, AKOn March 26, 2009, about 1400 Alaska standard time, a ski-equipped Cessna 170B airplane, N2989D, sustained substantial damage during takeoff from a remote frozen lake, about 5 miles southwest of Dillingham, Alaska. The airplane was being operated as a visual…Accident 20090326003959ACessna 337C · Stillwater, OK(-23) [privacy data omitted] (pilot of Cessna 337, N373E) departed a private airstrip located about 9 miles south of the Stillwater, OK airport. Witness statements indicate the pilot departed about 0810 (CDT) and maneuvered close to the private airstrip until…Incident 20090326003439ICessna 310K · Long Beach, CA(-23) On March 26, 2009, Cessna 310K, N7022L, departed Long Beach airport (lgb) for chino airport (cno). Prior to landing at cno, the pilots noticed the nose gear was not in the down and locked position. They did a low pass-over the runway in cno and ground…Incident 20090325012369IAirbus A320232 · Chicago, IL(-23)On April 3, 2009, I participated in a sosap erc meeting as the FAA representative. During the meeting a report was reviewed that indicated two aircraft may have been damaged during dispatch (pushback) at Chicago o’hare on March 25, 2009. One aircraft, an…Incident 20090325012329IAirbus A319131 · Chicago, IL(-23) On April 3, 2009, I participated in a sosap erc meeting as the FAA representative. During the meeting a report was reviewed that indicated two aircraft may have been damaged during dispatch (pushback) at Chicago o’hare on March 25, 2009. One aircraft,…Incident 20090325009869IDougla TA4J · Topeka, KS(-23) The pilot was participating with an air refueling test with a Boeing company tanker in N252WL, a Douglas TA-4 skyhawk, when he experienced a total electrical failure. The pilot deployed the ram air turbine generator decided to terminate testing and load…Accident 20090325004739AReimus FR1 · Paso Robles, CAOn March 25, 2009 at approximately 1000 hours local time the pilot of an experimental homebuilt departed Paso Robles airport (prb) for a local flight. At approximately 30 to 40 minutes into the flight the pilot stated that the engine started running rough and…