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 20120212001469ARockwell International 114 · Hilton Head, SCOn February 12, 2012, at about 18:52 eastern standard time, a aero commander (AC-11) aircraft N4851W registered to commander 114 corp operating as 14 CFR part 91 landed on rwy 21 at Hilton Head island airport (hxd). Aircraft ran off the left side of runway…Accident 20120211002499ASchweizer 269C · Las Vegas, NVPilot stated that he was demonstrating a hovering turn around a point, described as being a car tire. As the aircraft entered a downwind condition the pilot lost control and the tailrotor made contact with the surface causing it to seperate from the tailboom.…Accident 20120211002109ALearjet 31A · Wheatland, WYOn 02/11/2012 at approximately 1200 MST, N382AL, a Learjet model 31A aircraft sustained substantial damage during rollout on runway 8 at Wheatland, (kean) airport, WY. There were no injuries to the four persons on board. Weather at the time was VMC.Incident 20120210004319ICessna 172P · Ft Pierce, FLDuring level flight aircraft started smoking with an acid smell in the cockpit. All gage readings were eratic and PIC made an emergency landing at Ft Pierce airport.Accident 20120210004059ACessna 172I · Mccarthy, AKUpon landing pilot lost directional control, aircraft hit a snow bank and flipped over causing substantial damage. One person on board, no injuries.Accident 20120210003039ACessna 172N · Floresville, TXAircraft was returning to Stenson Airport, from south practice area. Aircraft crashed in open pastureAccident 20120210002999ABell 206A · San Antonio, TXAircraft was dispatched on a hospital mission. Aircraft was at the airport, kssf, at the time. Start was normal, runup was normal, and t/o to a hover was normal. Aircraft systems checked normal, as did flight control response check and c.g. check. Aircraft…Accident 20120210002219ASocata TBM 700 · Madison, WIOn February 10, 2012 a Socata TBM-700 bound for fort meyers (fmy) registration number N850LM, crashed shortly after rotation on takeoff from runway 21 in Madison Wisconsin (msn). The aircraft pitched up and rolled to the left with the left wing tip striking…Incident 20120210001619IPiper PA-34-200T · Goodyear, AZRight main gear collapsed on roll out.Accident 20120210001229ACessna 152 · Tamiami, FLAirman was returning from X51, 2nd solo. Airman entered left downwind runway 27L. A speci weather report was issued by ATC, winds 160/07. Light rain was reported. Airman states he felt a wind shift, slight tailwind. Upon flare and role out airman porpused and…Accident 20120209004219ACessna T182T · Lebanon, NHOn February 9, 2012 at 1345 eastern standard time, N6062E, a Cessna T182T,was substantially damaged when it impacted terrain while returning to land after takeoff from Lebanon Municipal Airport (leb), Lebanon, new hampshire. The certificated pilot was fatally…Accident 20120209002059ACessna 172M · Cusick, WADeparted coeur d'alene airport (coe) bound for sand canyon airport (1S9). Pilot stated that upon reaching cruise altitude he noticed the aircraft not performing normal and shortly after experienced power loss then engine failure. Attempted to restart engine…Accident 20120209001749ACessna 210 · Mountain Green, UTThe aircraft left Douglas, Wyoming converse county airport (dgw) on February 9, 2012 at approximately 1000 Mountain standard time (MST) for salt lake city, Utah (slc). The pilot planned to fly to slc, pick up a passenger and return to dgw. The passenger had…Incident 20120209001069IBeech B200 · Lubbock, TXDuring cruise flight at FL260, the inner right hand windshield shattered. Pilot performed emergency desent and landed without incident Lubbock, TX (lbb).Accident 20120208005619AVarga 2150A · Frankston, TXPilot departed Aero Estates - T25 at approx 1015 for jso to obtain fuel. Departed jso at approximately 1100 to return to Aero Estates - T25. Reported overdue at approx 1530. Contact made with longview flight services approximately 1700 to try and locate…Accident 20120208002259AMaule MX-7-235 · Tea, SDOn February 8, 2012, at approximately 1230, an MX-7-235 was coming into land at Tea, SD on runway 34. The weather was VFR and the wind was light and variable. After touching down the pilot lost control of the aircraft causing it to ground-loop. The aircraft…Incident 20120208001759ICessna 414A · Sandpoint, IDThe aircraft was on a IFR flight from tacoma, WA. To Sandpoint, ID. After turning at initial approach fix over hayden, ID pax heard vibration noise in cabin. The pilot then noticed that the cabin altimeter was climbing and the cabin pressure was dropping.…Incident 20120208001559ICessna 402C · San Juan, PRAircraft departed San Juan puerto rico and climbed to 7000 ft. pilot had a door warning light. Pilot checked the crew door checked the crew door latch. The door came open dislocating the pilot's shoulder. The pilot declared an emergency with San Juan approach…Incident 20120208001499IMooney M20J · Bartow, FLThe pilot was landing on runway 5 at Bartow airport (bow) at approximately 2045 on February 8th, as he lowered the nose gear after touchdown he stated he saw a shadow flash by the runway light and then felt the plane hit something solid. The propeller and…Incident 20120208001459ILake LA-4 · Keene, NHThis office was notified by the new england region operations center that:"N69UL, landed runway 02, landing gear collapse, runway 02 closed, no injuries, damage unknown at 1710 EST, 2/8/12. This inspector spoke with pilot on 2/9/2012 and was informed that…Incident 20120207002659IMcdonnell Douglas DC-9-82(MD-82) · Omaha, NEOn February 7, 2012, American airlines flight 1349 departed Omaha, NE, Eppley Airfield, enroute to dallas, TX. During climb, the crew requested clearance from air traffic control to return to Eppley Airfield, due to a compressure stall at 13,000 feet. The…Accident 20120207002169APiper PA-28-140 · Greenville, SC7 Feb 2012, pilot took off in N4592R, PA-28.-140. He made an approach to runway 19 at Greenville downtown airport, south carolina. After landing, the aircraft veered to the right. The pilot corrected with left rudder and brakes. Pilot let off the left brake…Accident 20120207001269AAeropro CZ Eurofox LSA · Winter Haven, FLAircraft N701CF ran off taxi runup area while under power and struck hanger door.Incident 20120207001199ICessna R182 · St. Cloud, MNPilot failed to extend the landing gear.Incident 20120206013069IPiper PA-38-112 · Newport, ARCruise altitude at 1800 AGL engine began to loosing power and cutting out. Not able to maintain safe altitude. Chose nearest safe farm field adjacant to hwy 14, upon landing the nose gear touched down and sunk in soft soil. The aircraft rolled over on its…Accident 20120206001439APiper PA-30 · Culpeper, VADuring approach to land at Culpeper the gear failed to operate when gear handle was placed down. Pilot attempted to initiate emergency gear extension procedures and made a precautionary landing. During touchdown the gear collapsed and the props struck the…Accident 20120206001189AMoore Byron J Zealot · Mineola, FLWitnesses reported that at aprox. 10:39 am they watched [privacy data omitted] began his landing approach from the north, approx. ¾ mile from the air strip. While making a left banking turn on finial, they observed the left wing, of the plane, drop and the…Incident 20120205004919IAircraft Mfg & Development CH 2000 · Corona, CAAicraft departed runway 7 at kajo. Upon rotation, Aircraft became uncontrollable and was forced to make a hard landing causing a propeller strike, and seperating the nose gear from Aircraft. Aircraft came to rest on runway 7.Accident 20120205002089ARockwell International S-2R · Stibnite, IDPilot flared the aircraft for landing but the rate of desent did not decrease. The aircraft hit the runway harder than intended and bounced back into the air. The aircraft came back to the runway and upon rollout the right landing gear collapsed. The right…Incident 20120205001259IInfinity Power Parachute Classic 2004 · Sebastian, FLOn 02/05/2011, aircraft N56754, an exhibition light sport power parachute, struck a power line while returning to the Sebastian municipal airport located in Sebastian, Florida. The pilot, [privacy data omitted], returned to the airport due to a rapidly…Accident 20120205000919APiper PA-18 · Thedford, NE[privacy data omitted] Lost control of his aircraft during the landing roll when the main wheels rolled over a patch of ice on the otherwise dry runway. The aircraft veered to the left and hit a snow drift, causing it to turn over onto its back. The weather…Accident 20120205000799ACessna 172N · Fresno, CAThe aircraft was stolen from the buchannan airport in concord CA(kccr) on Saturday February 4, 2012, and found crashed on Sunday February 5, 2012 at approximately 1605 PST. The sole occupant operating the controls had been his student pilot certificate…Accident 20120204003639APipistrel Virus 912 · Ray, MIWitness' stated that aircraft was running rough during engine run-up and take-off. The engine failed at approximately 200 feet AGL. The PIC tried to make an emergency landing on a nearby golf course and while manuevering to land the right wing tip struck the…Accident 20120204003279ACessna T206H · Show Low, AZThe aircraft departed the Show Low airport on runway 24 in route to las vegas NV. The flight began before the first light of day.a witness who was driving by the airport noticed the airport landing lights were on. They then noticed an aircraft with strobe…Accident 20120204003239ACessna R182 · Colorado Spring, COOn February 4, 2012, N2696C, a Cessna R182, was substantially damaged while landing at the city of Colorado springs municipal airport. One soul on board received minor injuries. VFR conditions prevailed at the time.Incident 20120204001649IRaytheon 400A · Scottsdale, AZInitial report of 'the right main landing gear light did not come on during landing' - indicating that the gear was not fully deployed. Pilots aborted landing and circled airport to investigate. Found that switching the gear indicator lamp bulb from another…Accident 20120204001289AAlon A2 · Forks, WAThe pilot pulled the aircraft out of his hangar for a flight to Friday harbor (fhr). With his wife onboard he attempted to start the aircraft but the battery was dead. The pilot elected to hand prop the aircraft. The pilot stated that he had set the hand…Accident 20120204000939APiper PA-28R-201T · Kalispell, MTOn February 4, 2012 N38906, registered to the pilot, [privacy data omitted] of Kalispell, Montana, took off from Kalispell city airport (S27) runway 31 with himself and 2 passengers aboard. At @ 500 feet, as the aircraft began a left bank away from the…Incident 20120204000929ICessna 207 · Tyonek, AKOn final approach to Tyonek Airport at approximately 700' MSL and full flaps, aircraft began to sink. Pilot added power and reduced flaps to gain control. Aircraft hit tree approx. 100 yards from end of landing strip. Tree height was approx. 35 feet. Aircraft…Accident 20120203005239ACessna 172E · Dinsmore, CAAccident report "narrative" information as follows…student pilot and instructor were performing touch and go at Dinsmore, CA. On runway 27.aircraft veered off end of runway, cart wheeled and came to rest in field 100 yards beyond the runway's end. A post…Incident 20120203002019IBrunner Douglas Lancair Legacy · Port Orange, FLOn April 02, 2012, aircraft N241DB, a Lancair model legacy, crash landed after the main left main landing gear collapsed on take off roll. The pilot stated that he retracted the landing gear as he normally does afterwhich the left landing gear collasped. The…Incident 20120203001639IBeech F33A · Goodyear, AZOn February 03, 2012, in VMC conditions on approach to Goodyear Airport, AZ, [privacy data omitted] a student pilot while on a solo flight, reported an unsafe gear indication in his BE-33, N8240T. He landed without further incident. Atca, repair station…Incident 20120203001209IPiper PA-28RT-201 · Tooele, UTDuring an instructional flight in preparation for a CFI rating check ride and after several uneventful landings both pilots forgot to lower the landing gear. The student was at the controls. The CFI reported he was distracted during the turn to final looking…Accident 20120203001079AGarza Carlos Lancair IVP-TP · Boise, IDAirman aborted first take off for unk reasons before taxiing back for 2nd take off. On take off runway 10R, a/c was observed in climb to approx. 200 ft. pilot radioed intention to land and aircraft entered spin, impacting with ground between parallel runways…Incident 20120203000949ILockheed T-33 · St. George, UTPilot was conducting a local orientation flight for a friend. Performed two normal landings. When he extended the landing gear for a third landing the right main failed to extend. The pilot performed all possible checks and procedures to no avail. He elected…Incident 20120202021329IPiper J3C-65 · Danbury, CTOn 02/02/2012 at approximately 1715Z N87955 a Piper J3C-65 departed runway 35 after landing. The aircraft struck a runway sign with the right main wheel which caused the aircraft to nose over and the propeller to strike the ground. The propeller sustained…Incident 20120202007939ICanadair CL-600-2B16 · Hot Springs, VADuring landing, wind shear and gusty conditions were encountered. The nose wheel came down hard on touch-down, causing minor damage to the aircraft.Accident 20120202003249AGates Lear Jet 35 · Pueblo, COOn February 2, 2012, Learjet N31WS departed runway 8L during takeoff at Pueblo memorial airport, Pueblo, CO. None of the 10 souls on board were injured, but the aircraft received substantial damage. Instrument meteorological conditions prevailed at the time.Accident 20120202001609ABellanca 17-30 · Kansas City, MODuring landing on runway 19 at mkc, the nosegear locked to the extreme left, due to failure of the right nose gear steering rod end. This made the nose wheel steering inoperative, which caused the aircraft to slew to the left, eventually leaving the runway…Accident 20120202001449AAntonov AN-124-100 · Anchorage, AKFull registration of the aircraft is ra 82046.flight 4410 was descending for ted Stevens Anchorage intenational airport(panc) runway 14, via the "ellam two" arrival. At approximately 13,000' the aircraft experienced severe clear air turbulence which lasted…