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 20091212052849IChampion 7ECA · Eden Prarie, MNThe pilot was cleared to taxi east on alpha and hold short of runway 18. Because of the taxi speed approaching 18, the controller reminded Mr. Engstrom to hold short of runway 18. The pilot applied enough brake pressure to stop the wheels short of the hold…Incident 20091212052559IBombardier CL-600-2C10 · Atlanta, GADuring climb out recived a l caution message (aircraft returned to atl after t/o)removed and replaced the RH prsov due to mdc and acsc both flagging the RH eng prsov. Ops checked good iaw crj 700 amm 36-12-01REMOVE GG670-80002-7, 00510, ENG-2 .install…Incident 20091212052439IBeech A60 · Clearwater, FLWhile attempting to lower landing gear on aircraft N111XL gear failed to extend. Manual extention also failed as the gear crank handle would not turn. Aircraft made a gear up landing at kpie on runway 09Incident 20091212025739IBeech V35B · Springfield, ILEnroute from bmi to spi the pilot of N2050Z reported an electrical system failure. The pilot completed the abnormal checklist but was unable to restore electric power. Radio contact with spi ATCT was lost. The airman manually lowered the landing gear and made…Accident 20091211053169ACessna 182P · Payson, AZPilot landed hard and aircraft bounced into the air. The pilot states that he tried to apply power but there was no response to the throttle. The aircraft was nose up and the r.h. wing dipped or stalled out. When the aircraft touched down the second time the…Incident 20091211052369IBoeing 767223 · Raleigh, NCAmerican airlines flight 173 experienced a flight control problem. Landed rdu airport without incident. Contacted aal manager aircraft maintenance rdu Mr. Robert preston [privacy data omitted]. He stated maintenance reset the flap symmetry unit ops check ok,…Incident 20091211052359IEmbraer EMB-135KL · Raleigh, NCAircraft returned to rdu after takeoff with fuel indicator problems. System was mel'ed.Accident 20091211052279ACessna 310 · Pasco, WAPilot attempted to extend landing gear. Nose and left landing gear came down but the right did not. Attempted using the emergency extension procedure to lower the right gear but was unsuccessful. After several failed attempts to get the right gear to come…Accident 20091210053219APiper PA-30 · Port Mansfield, TXPilot departed VFR from sun ray, TX for Port Mansfield (T05), a four hour flight. An IFR flight plan was air-filed enroute. Pilot requested a desent to minimum vectoring altitude to attempt a visual approach. Aircraft was discovered 1.6 nautical miles east of…Incident 20091210053209IDiamond Air DA 20-C1 · Delta, UTStudent pilot on a supervised solo cross country experienced power loss during final approach to runway 30 at Delta, Utah. Aircraft landed short of the runway damaging one proeller blade when it struck a dirt burm. Aircraft was trucked to uvu maintennance…Incident 20091210053049IBeech A36 · Auburn, ALAircraft departed kcsg uneventfully enroute direct to kmbo. While in normal cruise flight at 6000 feet, the auto-pilot failed and the aircraft radios began to fail. Communication with atlanta center was lost. As all electrical power was lost, pilot made…Incident 20091210053029ICessna 172N · Pacoima, CAMr. Garcia stated he was giving dual instruction for the first time to Mr. Cohen on a flight from vny airport to whp airport for landing practice. Mr. Garcia was making the radio calls while Mr. Cohen was the pilot flying. Whp tower instructed them to enter…Incident 20091210052349ICessna 402B · Raleigh, NCTower notified aircraft that smoke was comming from the tail of the aircraft and returned to airport.Incident 20091210052329IBeech 58 · Lexington, KYOn December 10, 2009 N391MC was being operated under FAR part 91 for ebc currency requirements. The flight originated from Lexington, KY(lex) and various approaches were flown to local airports without landing. Upon return to lex a practice missed approach…Incident 20091210052089IColumbia Ai LC41-550FG · Harbor Springs, MIPilot attempted departure from Harbor Springs airport in blizzard weather conditions. The airport manager reported the runway as having patchy ice but clear of snow. Piloted reported braking difficult when he landed at 4:15P.m. that afternoon. During takeoff…Accident 20091210025979ABeech 200 · St. Louis, MOPilot reported to ATC he could not get the landing gear extended on approach to stl. He aborted the landing and tried to get the gear extended. After thirty minutes of trying, pilot was unsuccessful and landed gear up at stl on runway 24. There were no…Incident 20091210023759IPiper PA24260 · Casper, WYPrior to landing pilot reported to cpr tower that both normal and manual landing gear extension systems were inoperative. Pilot asked tower for visual conformation of gear position. While pilot was pumping manual extension handle tower reported landing gear…Incident 20091210022909IPiper PA28235 · Boulder City, NVOn 12/10/2009, at approximately 9:10 am, N8675W, a Piper PA-28235, serial number 28-10205 was taking off from the Boulder City airport (kbvu) when the engine quit just after takeoff (at approximately 50 to 100 feet AGL). The aircraft was piloted by dan…Accident 20091210022329APiper PA38112 · Ojai, CAInstructional flight in aircraft in which aircraft collided with tree/terrain resulting in both instructor and student sustaining fatal injuries. Witnesses discribed abnormally low flight, and aircraft movement similar to stall/imminent spin-type movements.Accident 20091209053429ABeech A36 · Eagle Pass, TXOn dec. 9, 2009, a Beech A-36 attempted to land at the Eagle Pass airport in heavy fog but was off course, east of the runway and hit two deer proof fences, t-post and post. The aircraft's right wing hit one of the metal post causing it to veer right and into…Incident 20091209052659ICessna 337C · San Juan, PROn December 9, 2009, Mr. Rene fernandez, private pilot certificate no. 584583365, departed isla grande airport in his Cessna 337, N2669S, for a pleasure flight with a friend, who is also a pilot. Around 20 minutes later he returned the airport for a landing.…Accident 20091209052479ABeech 35-33 · Lehi, UTOn December 9, 2009, about 1400 mountain standard time, a Beech 35-33 airplane, N316Z was substantially damaged during a forced landing following a reported loss of engine power near Lehi, Utah. The airplane was operated by the pilot who was the sole occupant…Incident 20091209052289IKuypers Nor Avid Heavy · Green Cove Spri, FLDuring water landing on st johns river one or more of the support struts for floats failed, causing aircraft to settle into water.Incident 20091209025749IPiper PA-24-260 · Casper, WYPrior to landing pilot reported to cpr tower that both normal and manual landing gear extension systems were inoperative. Pilot asked tower for visual confirmation of gear position. While pilot was pumping manual extension handle tower reported landing gear…Incident 20091208053189ICessna 172RG · Traverse City, MIPrivate pilot flying aircraft from left seat with flight instructor in right seat were doing touch and go takeoffs and landings in preparation for the private pilot's commercial pilot flight check. On the third landing while rolling on the runway at…Incident 20091208052999IMitsubishi MU-2B-60 · Lawrenceville, GAOn December 08, 2009 at 2315 local time, PIC gerald henson, ATP certificate #438534487 attempted to land Mitsubishi MU2-60B N610CA at gwinnett county airport (lzu) Lawrenceville, GA. The pilot stated that on approach, 50 feet above the runway, the aircraft…Incident 20091208052209IBeech A35 · Corvallis, OROn 12/08/2009, pilot of N8577A, an older 1948 bonanza was landing at Corvallis Oregon airport for purposes of takeoff and landing practice to include transitioning into night landings late in the afternoon. The pilot flew over the airport and entered left…Accident 20091208052159ACessna 172S · Kissimmee, FLCessna aircraft N5269X departed ism enroute to fxe with 4 soles onboard, piloted by luis manuel martinez blanco. There was no flight plan filed. The current weather was, 800 scattered, 2400' ceiling, 10 mile visibility. The field was uncontrolled at the time.…Incident 20091208052099IBombardier CL600-2D24 · Omaha, NEN906XJ, CL-600-2D24, operated by mesaba airlines as northwest airlink flight 3574 departed Omaha, NE, enroute to memphis, TN. The airplane returned to Omaha due to a gear warning light after takeoff. The crew reported that they received a gear disagree…Accident 20091208051999ARockwell IN 114 · Birmingham, ALAt 2018 CST on December 08, 2009, a small plane crashed at the Birmingham international airport (bhm). The aircraft was identified as an AC-11, registration number N5872N. There was one occupant and he was uninjured. The airplane departed monroe-walton county…Accident 20091208023129APiper PA38112 · Fresno, CAWhile on initial climb out from fat rwy 20L, the pilot indicated the engine started to backfire and noticed the engine RPM dropping and started to surge around 1800 RPM. The pilot immediately reported the emergency to fat tower ATC and started a descending…Incident 20091207857339IDehavilland DHC-3 · Talkeetna, AKWhile taxiing for take-off pilot hit and bent taxiway light stanchion with ski. No damage to aircraft.Accident 20091207053099ANew Piper A PA-46-500TP · Mendoza, TXDuring vectors for instrument approach to austin, N600YE entered a right turning rapid descent ending with ground impact. The pilot and one passenger were fatally injured.Accident 20091206053779AAerospatial AS 355F1 · Grand Canyon, AZAirman failed to secure the latches which secure the left hand engine compartment door. Aircraft departed las airport on a 14 CFR part 135 air tour to the Grand Canyon. While enroute to the Canyon at approximately bonnelli bay, the engine compartment door…Incident 20091206053609ICanadair CL-600-2B19 · Atlanta, GAAircraft N827AS experienced flap failure while inbound to Atlanta rwy 9L. Aircraft landed without incident.Incident 20091206052489ICessna 150L · Washington, NEThe student pilot was on a private pilot check ride with a designated pilot examiner (DPE). After completing air work at 3000 feet above ground level (AGL) the DPE announced, "simulated rise in oil temperature and decreasing oil pressure." The student pilot…Incident 20091206052169IBoeing 737-824 · Helena, MTCrew saw the #1 engine oil filter bypass annunciator light come on during cruise flight, crew followed qrh procedure and reduced power to idle, to see if bypass light would go out. The light did not go out, so crew completed inflight shut down procedures per…Accident 20091206051989APiper PA-32R-301T · Cape Hatteras, NCDuring takeoff roll Mr. Charles f. cole observed a turbocharger overboost indication on the cockpit instrument panel and aborted the takeoff. According to Mr. Cole the right brake of the PA-32R failed during the aborted takeoff causing the aircraft to exit…Accident 20091206025789ABeech V35 · Dodge City, KSWhile enroute from anoke co-blaine airport (kane) to dalhart municipal airport (kdht), the pilot encountered inflight icing conditions north of Dodge City, Kansas. The pilot stated that the pitot heater failed and caused the airspeed indicator to cease…Incident 20091206022859IBoeing A75N1 · Corona, CAPilotstated he touch down hard and bounce during landing. Made a go around and ground personnel noticed gear was hanging from airplane. He then madea short final landed runway 25 in grassy area.Incident 20091206022089IPiper PA28R201 · Lumberton, NJThe certified flight instructor/pilot-in-command was preparing the pilot undergoing instruction in commercial manuvers utilizing lesson #83 of their part 141 approved jeppesen instrument/commercial syllabus. This was in preparation for the commercial pilot…Incident 20091205052699IMcdonnell D MD-11F · Honolulu, HIDuring ups flight #34 from sdf-hnl, at a cruising altitude of FL 340, the #2 engine oil pressure dropped, followed momentarily by engine failure. The engine was shut down and appropriate checklists completed. The aircraft was past both equal time points so…Accident 20091205052199ACessna 172M · Diamond Point, WAPilot overflew the runway to evaluate the winds and runway condition. Noted conflicting wind indications and up and downdrafts as well as a crosswind while on final. All indications were normal and the aircraft touched down within the established airspeeds in…Incident 20091205051879ICessna 310D · Tampa, FLThe aircraft was on final approach to tpa with three green gear lights, the pilot was advised to increase his speed. When the gear was raised it did not seem normal. He was then instructed to circle to allow faster traffic to land. When he was cleared to land…Incident 20091205022729IPiper PA60602P · Concord, CAAfter completing a missed approach off runway 32R, Mr. Pike retracted the landing gear and set flaps to 20%. On down wind flaps were set to 40% landing gear was not extended. Aircraft landed with gear retracted. Landing gear warning activates between 13 to 15…Incident 20091204857369ICessna 152 · West Palm Beach, FLStudent pilot on a presolo flight test during landing flare yanked the flight control too fast at low speed stalling the aircraft. The flight instructor did not timely recover from this unusual attitude allowing the aircraft to crash on the runway. No…Incident 20091204053641IVarga Aircr 2150A · Livermore, CA1) Pilot was alone.2) battery was too low to use starter and he didn't want to take time to replace or charge the battery.3) pilot set the parking brake and chalked main tires.4) "cracked" throttle open and turned the magnetos on.5) pilot hand-propped the…Incident 20091204052332IPiper PA-44-180 · Key West, FLN7707G/PA-44 was stopped at runup area at runway 9, performing before takeoff checklist. N488W/stearman was taxing to runway 9 for takeoff, when it approached the runup area and struck N7707G. No injuries and minor damage to both aircraft.Incident 20091204052312IStearman 4CM-1 · Key West, FLN7707G/PA-44 was stopped at runup area at runway 9, performing before takeoff checklist. N488W/Stearman was taxing to runway 9 for takeoff, when it approached the runup area and struck N7707G. No injuries and minor damage to both aircraft.Accident 20091204051919APiper PA-31T2 · Harrison, MI12/08/2009, N.t.s.b. representative [privacy data omitted] visited the grr FSDO office and delivered a computer disc with accident pictures on it. She also told me that she had coordinated with the engine tech rep from pratt and whitney to have the engines…