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 20121018024239IBeech V35B · Tullahoma, TNPilot was distracted with radio traffic from an arriving helicopter and took his hand off the gear selector. He flared and settled into the runway until the prop struck the pavement. He turned the master switch off.NTSB, patrick murray in miami was notified…Accident 20121018024079ABeech N35 · Phoenix, AZPilot stated that he departed the prescott airport (kprc) at approximately 10:09 am for deer valley airport (kdvt). Pilot stated that oil pressure was normal on takeoff and climb out. Pilot stated that he climbed to 7,500 feet MSL and contacted albuquerque…Accident 20121018023379ADaniels Alan L Kitfox Series 7 · Plymouth, MAOn October 18, 2012, N555HT a Kitfox series 7 aircraft originated a 14 CFR part 91 flight from Plymouth, MA (kpym). The flight was being piloted by [privacy data omitted].the pilot was attempting to land on runway 24 when the aircraft porpoised multiple…Incident 20121018023349IPiper PA-24 · Lewiston, IDThe pilot departed Lewiston-Nez Perce County Airport (klws) enroute to glendale, Arizona with a planned fuel stop in mccall, Idaho (kmyl). On approach to mccall, the landing gear indicator showed the gear was not down and locked. The emergency gear extend…Accident 20121018023149AAlbright, Stan Kitfox Super Sport · Twin Bridges, MTAfter completing several takeoff's and landings on the accident flight, the pilot initiated his first full-flap takeoff in the accident aircraft. Immediately after takeoff, the aircraft rolled and yawed to the right, impacting the ground causing substantial…Incident 20121018022699IMooney M20F · Henderson, TXDuring final approach pilot put flaps down, checked all instruments, called final and landed without lowering his landing gear. Aircraft landed at approximately 60 mph and skidded approximately 300 feet before coming to a stop. No injuries to pilot and minor…Incident 20121018022689ICessna 172M · Gainesville, FLPilot was flying N5429R, a Cessna 172M, on approach into Gainesville, FL. The pilot detected the odor of smoke and noticed some smoke in the cockpit. Pilot shut off all electrical power. Smoke then cleared and pilot attempted to re-power the aircrafts…Accident 20121017023939ABeech A36 · Wausau, WIOn October 17, 2012 at 7:57 minnepolis center lost contact with the pilot of N121VP as he was cleared for a GPS approach to runway 12 auw, Wausau, WI. The aircraft landed 690 feet short of auw runway 12. The IFR rated pilot received serious injuries and the…Incident 20121017023889IFlight Design Ctls · Elyria, OHThe right main landing gear strut failed shortly after touchdown. This is a fixed gear aircraft. The aircraft, including the landing gear strut is made of composite material. In August of 2012, the aircraft was damaged during a hard landing. The nose gear and…Accident 20121017023699AAir Tractor AT-502B · Portales, NMOn October 17, 2012, at approximately 16:04CDT, an Air tractor AT-502, N598LA struck power lines while conducting aerial agriculture spray operations. The aircraft was approaching the field east of Portales, new Mexico from the south and struck the wires in a…Incident 20121017023169IPiper PA-28-161 · Beverly, MAOn 10/17/2012 at approximately 1300 (l),N8234D was conducting takeoff and landing practice at the kbvy airport. Runway 16 was in use and winds were calm at the time of the incident. The aircraft had completed three touch and go landings and was planning a…Accident 20121017022739AAerospatiale AS-355 · Tinicum Twp., PAPilot departed from his back yard heliport at about 6:30AM. Weather at the time was light drizzle and fog. Pilot impacted trees just after takeoff. Helicopter was destroyed due to fire after impact.Incident 20121017022439IBeech 1900D · Denver, COGreat lakes airlines flight 7250 departed den on runway 8 ascending to approximately 9500 ft. cabin alt high annunciator light illuminated. Flight crew heard a loud bang followed by a loud hissing noise. Flight crew did not recieve an annunciator light…Incident 20121016026949IMaxfield John Sonex · Belleville, MIOn Tuesday, October 16, 2012 at 6:04PM eastern time, an experimental amateur-built Sonex, departed the detroit willow run airport (kyip) runway 23L. While climbing through approximately 300 feet, the pilot declared experiencing smoke in the cockpit. The…Accident 20121016024289ACessna 182P · Maryville, TNPilot elected to land at unapproved landing strip, parking lot to racetrack, which by local knowledge 30 years ago someone landed there. Landing area was 800 feet long, dirt, with loose gravel, wash out ditches, and downhill. Aircraft tire marks and skid area…Accident 20121016024259ACashmer Philip M Sonex · Crossville, TNPilot records are unavailable due to such serious injury and comatose state. Open brain injury, lost of eye, and severe head trauma. Wife has multiple upper body trauma with broken shoulders, ribs, arms, and facical fractures. Pilot apparently was not wearing…Incident 20121016023929IChampion 7ECA · Eden Prairie, MNThe aircraft involved departed buffalo airport (cfe) on 10-16-2012 enroute to Flying Cloud Airport (fcm). Weather at fcm was clear with winds 180 at 6 knots. During rollout on runway 10R the pilot lost directional control of the aircraft. To avoid hitting the…Accident 20121016023899AYoung Robert Herman Woody Pusher · Cloverdale, INThe pilot took off from a private family airport heading west and turned left to a heading of east for the downwind leg while continuing to climb. When the power was retarded to set cruise power, the engine quit. The pilot turned slightly north to clear some…Incident 20121016023189IFairchild James Challenger II · Odessa, FLOn October 16 2012 at 1558 EDT a Challenger II, experimental amateur built aircraft registered to [privacy data omitted] lost power in the engine and landed in an open field sustaining minor damage to the landing gear tension cables. Visual meteorlogical…Incident 20121016022889IBeech 95-B55 · Bismarck, NDOn October 16, 2012, at 1632 central daylight time, a Beechcraft, model V35B, N752CA, collapsed on the runway after the landing gear appeared to have failed, during landing at the Bismarck Municipal Airport, in Bismarck, north dakota. The pilot was not…Incident 20121016022169ILuscombe 8F · Greeley, COOn 10/16/2012 at approximately 0820 hrs, MDT, N1414B a Luscombe model 8F aircraft sustained minor damage while landing at Greeley-Weld county (kgxy) airport, CO. The two occupants on board were uninjured. Weather at the time was visual meteorological…Accident 20121015028559AGrumman Aircraft ENG C-1A · Willow, AKOn October 15, 2012 about 15:55 adt, N27PH, a Grumman C-1A trader was substantially damaged when it impacted the ground 12 miles west of Willow, Alaska. The pilot in command, the sole occupant of the aircraft, was fatally injured. A post impact fire ensued.…Incident 20121015024649IMcdonnell Douglas MD-11F · Louisville, KYDuring a cat iii flight confidence check while landing at sdf, the aircraft flared normally, touched down, but nose continued to rise. The pilot regained control, disconnected the a/p and continued rollout. The aircraft tail struck the runway causing dmage to…Accident 20121015024639ACirrus Design SR20 · Parker, AZVFR flight from smo to sna to prc airports. Pilot declared an emergency due to a fuel problem and changed destination to P20 airport. Aircraft was unable to make it and landed on a plateau aproximately 11 miles northeast of P20 airport.Incident 20121015024619IBombardier CL600-2D24 · Omaha, NEDuring approach received slat fail message. Requested emergency equipment and landed without incident.Accident 20121015023569ACessna 172R · Simpson, LAOn October 15, 2012 at approximately 2055 local time, Mr. James e. roberts, pilot certificate number 438354598, was pilot in command of a Cessna 172, N2126R and departed pineville municipal airport (2LO) on a personal flight to orange, TX. A line of…Accident 20121015022499AAeropro CZ A240 · Moss Beach, CAFAA radar data indicates the aircraft departing Half Moon Bay Airport (haf) from runway 30 on 10/15/2012 at or about 05:13 PDT, 20:13 UTC. The radar plot indicates the aircraft departing to the north at 05:13:47 with a reported altitude of 600 feet. The…Incident 20121015021779IMaule M-4-220CPilot stated he was landing on the grass runway and the wind came up and he lost controlIncident 20121014026179IEmbraer EMB-145XR · Chicago, ILAircraft departed ord and lavatory smoke detector activated and then cabin and cockpit had odor and presence of smoke. Crew returned to ord landing on runway 27L and deplaned passengers at H/H1 taxiway via stairs. No injuries to crew or passengers reported.Accident 20121014023879APiper PA-28-151 · Marana, AZOn October 14, 2012 at approximately 1910 MST, aircraft N151SV impacted the ground in a remote area in pima county, Arizona. The pilot, who was the sole occupant onboard, suffered fatal injuries. The aircraft last departed benson, AZ (E95) at approximately…Incident 20121014023359IPiper PA-28-181 · Farmingdale, NYPilot departed runway 19 at Republic Airport without receiving taxi or take off clearance.Accident 20121014022679AAirborne Windsports PTY XT-912 · Winter Haven, FLThe witness observed prior to the accident the aircraft had perfomed at least two touch and go's and stated nothing seemed abnormal but commented that it seemed a bit windy for an ultra light to be out and the winds felt to be about 10-15 knots. The aircraft…Accident 20121013028149APiper PA-18A 150 · Soldotna, AKThe aircraft took off from sxq on 10/13/2012 at 0137 adt from rwy 7, turned south then west to the coast. Upon reaching the coast, the a/c turns north heading past kenai. During this time the a/c is flying at approximately 500 AGL. The a/c heads west out over…Accident 20121013024819ABell OH-58A · Jackson, TNWhile maneuvering in support of local law enforcement the pilot reported that low rotor RPM warning sounded. Pilot reported lowering collective and maneuvering for autorotative decent and landing. Aircraft landed on a sloped surface resulting in damage to…Accident 20121013024279APiper PA-38-112 · Corona, CAN4309E executed an emergency landing when aircraft lost power. N4309E landed south of the runway at kjao and substained heavy damage.Incident 20121013024209IBeech V35B · Memphis, TNFlap position indicator malfunctioned during approach and landing. Pilot's attention diverted and failed to extend landing gear. Landed without the landing gear extended.Accident 20121013023732AHughes OH-6A · West Chester, PAOn Saturday, October 13, 2012, at approximately 0920 local time, a five-ship formation of Hughes 500 helicopters from lancaster airport, PA (lnr) arrived to conduct sightseeing rides at a rotorfest event at Brandywine Airport (koqn), PA, an uncontrolled…Accident 20121013023652AHughes/Helicopter Assocs 369A · West Chester, PAOn Saturday, October 13, 2012, at approximately 0920 local time, a five-ship formation of helicopters from lancaster airport, PA (lnr) arrived to conduct sightseeing rides at a rotorfest event at Brandywine airport (koqn), PA, an uncontrolled airfield with…Incident 20121013023639ICessna 172C · Ridge Manor, FLFlying at 2500' cruise at 2500 RPM engine suddenly lost power, RPM dropped to 1500, altitude could not be maintained, mag check during flight and engine quit, would not restart and aircraft continued to glide until landing in cow pasture.Accident 20121013023219APiper PA-23-250 · Charlotte Amali, VIOne passenger survived the accident, and was found at sea. Night visual meteorological conditions prevailed. Radar data revealed that the target identified as the accident airplane climbed to 1,700 feet after departure from tisx, where it leveled in cruise…Incident 20121013022409IStumpfhauser Richard F Slipstream · Fresno, CAWhile performing phase 1 flight test, during normal cruise, engine ceased operation. Pilot tried numerous times to restart the engine but was unsuccessful. The pilot then performed an off-field landing on a dirt field and upon landing, the landing gear…Accident 20121012026649APiper PA-28-140 · Allentown, PAOn October 12, 2012, about 1835 eastern daylight time, a Piper PA-28-140, N15037, operated by ace pilot training inc., was substantially damaged during a forced landing in a corn field following a partial loss of engine power during initial climb from Lehigh…Accident 20121012026529ASikorsky S-55B · Yorktown Height, NYOn October 12, 2012 [privacy data omitted], holder of commercial pilot certificate no. [privacy data omitted] Acted as pilot in command (PIC) of a Sikorsky S-55 registration number N443FD, s/n 55-1046. [privacy data omitted] Operated N443FD from newton NJ to…Incident 20121012026209ICamair 480OkIncident 20121012024569ICessna 207A · Tuluksak, AKPilot landed and was taxiing to pick up passenger, first flight in for pilot that day to tulusak (tlt). Sun was low on horizon and in pilots eyes blinding him. The pilot being blinded by the sun caused the collision with the wood stove. The wood stove had…Incident 20121012023559IPiper PA-22-150 · San Marcos, TXPilot was performing touch and go arounds, on the fifth take off during at rotation aircraft veared left and pilot could not prevent ground looping with impact to right wing tip. No major structural damage to aircraft but damage to right wing tip added…Incident 20121012022719ILearjet LR-35 · Ft. Lauderdale, FLOn October 12, 2012, aircraft with a venezuelan registration, YV499T departed Fort Lauderdale Executive Airport (fxe) for a test flight. After the test flight was accomplished, during descent to fxe, pilot's ess bus circuit breaker (cb) popped resulting in a…Incident 20121012022659IDassault-Breguet Mystere Falcon 900 · Omaha, NENose gear would not retract after departure.Incident 20121012022449IEmbraer ERJ 190-100 IGW · Philadelphia, PAAt approximately 6000 feet inbound, the captain saw a large bird flash by his left window. Immediately thereafter, the #1 engine shut down and the flight crew experienced several icas fault messages. After the engine failed the crew followed the qrh…Accident 20121011024969ARobinson Helicopter R44 II · Fredericksburg, TXOctober 12, 2012, this office received a call from com. Center at 9:30 CDT, reporting a Robinson R44 helicopter accident in Fredericksburg, TX. The aircraft crashed near a mountain site fatally injuring all tree occupants on board. Post accident…