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 20171026021809IPiper PA-28R-180 · Riverside, CANo gear down indication on approachto ral. Manually extended gear for landing iaw pilot operating handbook.Incident 20171026021569IPiper PA-28R-201T · Brighton, TNTurbo Piper iii N551DK (P28R) departed October 26, 2017, from symrna, TN. (Mqy) on an IFR flight plan heading southwest to Millington, TN. (Nqa). At 1450Z with the aircraft descending from 6000 to 3000 feet, the pilot heard a thump from the engine…Incident 20171026021319ICessna 152 · Denison, TXOn October 26, 2017 a student pilot flying solo was conducting touch-and-go?s in aircraft N422JP, a Cessna CE-152 on runway 17L at north Texas regional airport (gyi) in Denison, TX. On the 4th touch-and-go the pilot reported having a hard landing which…Accident 20171026021269ASix Chuter West Legend XL · Mabton, WAOn October 26, 2017, at 0900 pacific daylight time, a 2016 Six Chuter West LLC. Legend Xl, registration number N781SC, impacted terrain following contact with a power line during an instructional flight. The pilot flying was seriously injured, instructor…Incident 20171026020389IBeech B200 · Englewood, COAircraft was at FL280 about 100 miles out of denver, CO and the pilot noticed the gear unsafe light came on, located in the gear selector handle. Pilot looked outside and saw the gear door was open, upon closer look the pilot could see a tire but had no gear…Incident 20171026020379IPiper PA-24-250 · Selma, ALOn October 26, 2017 the pilot of N6640P was conducting a local area flight which included multiple touch and go landings in Selma, Alabama (ksem). While conducting the third touch and go landing the pilot stated that he heard and felt what he thought to be…Incident 20171026020369ICessna 510 · Charlotte, NC10-26-17 1620 Local. In cruise flt at 28000 ft the left windshield shattered. Declared an emergency, executed an emergency decent and requested clt. Repositioned to right seat and landed without further incidentAccident 20171026020359AAirbus EC130 · La Paloma, TXOn October 26, 2017, at 8:40AM CST, an Airbus EC130 helicopter bearing registration number N22TZ, registered to kestrel holdings LLC, suffered rotor blade damage to one blade when a weight came off of a game net when fired from the helicopter. The weight…Accident 20171026020349AStinson 108-2 · Lewiston, IDDuring landing rollout the pilot lost control and ground looped the airplane. As the airplane veered right and departed the runway, the left wingtip struck the runway causing damage to the outboard wingtip and left aileron, and broke off approximately half of…Incident 20171026020332ICessna 182P · Hayward, CAHayward, CA (hwd): N1216M, C172, on taxi to parking ran into a parked aircraft (N854FM, C525) doing damage to both. [privacy data omitted] POB: 1, injuries: none, damage: substantial 10/27 0200Z ntsb/little, oak FSDOIncident 20171025024799ICessna 208B · Galena, AKWhile attemting to make a left turn on an icy ramp the left brake locked, the pilot applied reverse thrust but the prop didn't go into reverse and instead caused the air raft to lurch forward and strike a shed.Incident 20171025021469ICessna P210N · Waco, TXOn October 25, 2017 aircraft N507HH was cleared for takeoff from Waco Regional Airport (kact) rwy 19 at approximately 1100AM. While on takeoff roll the pilot reported feeling abnormal vibration, immediately thereafter the nose landing gear collapsed causing…Incident 20171025020329ICessna T210M · Erie, COOn October 25th, 2017,N6025N, a Cessna T210A, during VMC conditions, the pilot departed centennial airport, (apa) Colorado around 0800 am. During survey operations, near Erie, CO, at an altitiude of 7000' MSL, the pilot heard a loud noise and saw the oil door…Incident 20171025020319ICessna 140 · Ashley, NDPilot was conducting a wheeled landing and upon touchdown pilot lost control and the aircraft nosed over onto its back. Pilot stated that cross winds may have contributed to the incident.Incident 20171025020309ICanadair CL-600-2B16 · Birmingham, ALN902BW landed on runway 24 at bhm and was asked by ATC to take taxiway H-4. When unable to they were asked to exit at taxiway H-2. N902BW turned off onto H-2 and was unable to complete the turn and ran off the taxiway and into the grass.Incident 20171024020299ICessna 550 · Baton Rouge, LAApproximately around FL 300 pilot experienced a N1 rollback and diverted to btr.Accident 20171024020289ASchweizer G-164B · Tracy, CAA Schweizer ag aircraft G-164B N8494K took off from haley flying service's private airport in Tracy, CA. For a training mission, pilot performed landings/take offs at a new jerusalem airport and then returned to haley's private airport. Aircraft landed and on…Accident 20171024018079ARobinson Helicopter R22 Alpha · Arlington, WAOn Tuesday, October 24, 2017 at 1315 hrs PST, a Robinson R-22 aircraft that did not have a current registration, N8537J was flown by a commercial pilot who did not hold a current medical certificate. It was operated from the pilots home. The pilot departed…Accident 20171024014999ACessna A185E · Gig Harbor, WADuring the landing roll out the left main tire ruptured. This caused the aircraft to swerve off the side of the runway. Damage occurred to the left main gear, left wing and left horizontal stabilizer.Accident 20171024014989ABell 206B · Groom, TXOctober 24, 2017, approximately 1540 local time, N60EA, a Bell 206B helicopter sustained substantial damage during a forced landing after a total loss of engine power while on approach to A private landing zone near Groom, Texas. The pilot was not injured.…Accident 20171024014969AAir Tractor AT-502B · Olton, TXOctober 24, 2017, approximately 0820 local time, N502G, an Air tractor AT-502B airplane impacted into a field about five miles west of Olton, Texas. The pilot sustained serious injuries and the airplane was destroyed by a post impact fire. Airplane was…Accident 20171024014959ACessna T210N · Eagle, COPilot attempted to depart Eagle airport and aborted the takeoff due to aircraft not developing full power. Had maintenance trouble shoot and do several runups. Pilot took off from Eagle airport and performed two touch and go's before making a full stop…Incident 20171023021459IPiper PA-31T · Tyler, TXOn October 23, 2017 @ approximately 1317 CDT aircraft N53AM, a Piper PA-31T, serial number 31T-7920037 reported gear problem while inbound to Tyler, TX (tyr) airport. The pilot made several passes to have twr ATC look at the gear; they reported the left main…Incident 20171023020269IKeegan John W Lancair Propjet · Boca Raton, FLPart 91 operator, experimental amateur built Lancair liv-pt propjet, N1115JK. Aircraft had an unsafe gear indicator. Aircraft made a pass and the left main gear appeared up. Pilot orbited to trouble shoot. Aircraft attempted landing and gear collapsed upon…Incident 20171023020259ICessna 402C · Bedford, MAAircraft was on final approach to kbos to runway 04R, pilot turned on overhead light to view landing chart. Shortly after he noticed dust particles in the air then had a smell of something burning. Pilot noticed a red flame come out of the overhead panel.…Incident 20171023020249ICessna 172M · Tamiami, FLOn October 23, 2017 a CFI and student were practicing a power on stall and when they went to level the aircraft after the maneuver they noticed that the right aileron was not responding to control inputs. They initially headed to ktnt but when they realized…Accident 20171022024019AGreat Lakes 2T-1A-2 · Xenia, OHUpon landing the pilot lost control of the aircraft due to gusty winds. The aircraft exited the runway into the grass and flipped on it's back, causing substantial damage. There were no injuries to the pilot who was the only person onboard the aircraft. The…Accident 20171022023659AAeronca 7DC · Salinas, CAThe airman was completing a local flight; during the terminal phase of flight; the airman received the latest weather via the automatic terminal information service (ATIS) (information echo 1953 uct calm winds visibility 10 miles, clear skies, temperature 23°…Incident 20171022020239ICessna 172R · Wilmington, NCIt was reported to the gso FSDO by the dom of air Wilmington that their part 135 aircraft, N53340, had sustained damage to the nose landing gear, nose landing gear wheel pant, and firewall. Management personnel from the operator were unable to identify the…Incident 20171022020229IHall Nathan W SHA Glasair · Santa Maria, CALeft main landing gear collapsed on roll out phase of touch and go. Left wing tip contacted the ground and the aircraft slid off the runway. The NTSB elected to catagorize this occurence as an incident not an accident.Incident 20171022020219IBombardier BD-100-1A10 · Oklahomah City, OKOn 10/22/2017 at 0430 CDT above aircraft with pilot and co-pilot onboard for a positioning flight reported vibration on RH engine. The aircraft returned to departure airport kpwa and landed without further issue. After landing inspection revealed a medium to…Incident 20171022020209ILearjet LR-45A LR-45 lost its left upper engine cowling during climb-out after takeoff. The aircraft sustained minor damage.Incident 20171022020199IBell 407 · Fourchon, LAAircraft departed SS207A to return to SS207D, a satellite platform, to pick up four remaining construction crew members. Pilot initiated an approach to overfly the middle of the crane boom cables, but felt a twang and/or bump as the aircraft approached…Incident 20171022020189ISocata TB-9 · Naples, FLAirman was returning from a safety training event and upon landing rwy 14 with a 10-knot crosswind, the aircraft bounced and began to porpoise. As the ocillations grew the prop struck the ground and the nose wheel blew causing the aircraft to roll off the…Accident 20171022018069AQuicksilver Sprint II · East Bridgewate, MAPilot elected to atempt an off airport landing on a gravel berm road between two cranberry bogs. Just prior to touchdown he noticed he would not clear an existing rise at the beginning of the berm road. He added power but struck the rise. The left main…Accident 20171022014979AAviat A-1B · Montoursville, PAWhile landing at ipt the left wheel brake remained locked resulting in loss of control and subsequent ground loop.Accident 20171022014949ACessna 150H · Pottsville, PADuring landing attempt, pilot lost control of aircraft resulting in accident on the left side of the runway abeam the 1000 foot markers. Cross winds were reported on airport AWOS and described by the pilot as very gusty with possible windshear along with…Accident 20171021024109AChampion 7GC · Gerlach, NVBlock 16: in 2009, the O-290-D2B series engine was removed and the O-320-B2B series engine was installed. Block 25: winds was reported as a 15-20 knots crosswind. Block 32, corrective action: the pilot was counseled by a NV FSDO ops inspector on 10/26/2017,…Accident 20171021022499ARaytheon B200 · Anchorage, AKAirman reported for duty on October 20,2017 at 1830 Alaska standard time (ast). Airman was on weather hold for most of his shift. After waiting for three hours airman went home to get some rest. Airman was notified at 0113 ast that the weather had improved…Accident 20171021021799AExtra Flugzeugproduktions-Und EA 300/L · Four Corners, CAOn 10/21/2017, N414MT departed Gillespie Field at approx. 1550. Aircraft impacted n 32 56.597 / w -116 45.872, within the el capitan reservoir area. Aircraft destroyed. Two souls on board, no survivors.Accident 20171021021519AAmerican AA-1A · Maricopa, AZPIC along with one passenger took off on runway 34 over powerlines marked with aviation marker balls. After approximately 30 minutes, PIC began approach on runway 16. While approaching runway, aircraft struck powerlines near end of runway with left main…Incident 20171021021449IPiper PA-24-260 · Greenville, TXOn October 21, 2017 @ approximately 1350 CDT aircraft N8571P a Piper PA-24-260, serial number 24-4028 landed at Greenville, TX (gvt) airport, with the landing gear in the up position. There were two people on board, both pilots; no injuries were reported and…Incident 20171021021259IMooney M20TN · Centennial, COATIS report: winds 31018G26 On approach to runway 35R, pilot was aware of winds and crosswind component. Pilot states aircraft was capable of landing with crosswind component. Upon touchdown, aircraft ballooned up, touched down a second time, ballooned again.…Incident 20171021020179IWhitten Robinson Aventura II · Rockledge, FLOn 10/21/2017 an aventura 2 made a gear up landing at the Rockledge, Florida airport. When interviewed the pilot stated that while inflight the gear would not extend and that he elected to make an emergency gear up landing on the grass at the airport.…Incident 20171021020169ICessna 182A · Arecibo, PRWhile on approach to landing the left wing tip cover came loose and struck the left horizontal stabilizer creating a dent on that surface. The pilot was able to land without any further incident.Incident 20171021020159IBeech N35 · Ashtabula, OHWe had just completed 5 commercial maneuvers of various types to a landing on runway 27. These were mostly 360 -degree spirals and 180-degree engine out. Upon takeoff from the 5th landing, I opted not to retract the gear as we were entering the pattern for…Accident 20171021014909ACessna 120 · New Bern, NCThe PIC flew the CE-120 on a flight from (ocw) airport the morning of the accident to his home base airport (ewn). He decided to work in the pattern to do some practice takeoff and landings. The first landing went well, but on the second landing attempt the…Accident 20171020021579ACirrus CIRRUS-SR22 · San Carlos, CAOn 10/20/2015 at approximately 17:57 PDT, N3636E departed runway 30. In a statement from the pilot, just after rotation, he stated the aircraft didn?t feel right so he aborted the takeoff, ran off the end of the runway, striking a ditch, and going through the…Accident 20171020020952AStaudacher Jon S-600F · Farmville, VAThe accident involved two experimental aircraft, N25YD (pitts S1-C) and N27KJ (Staudacher S-600F). The pilot of N25YD had just completed his practice session in the aerobatic box and was returning for landing. The pilot of N27KJ had just entered the aerobatic…Accident 20171020020932AYoung David E Pitts S1-C · Farmville, VAThe accident involved two experimental aircraft, N25YD (pitts S1-C) and N27KJ (staudacher S-600F). The pilot of N25YD had just completed his practice session in the aerobatic box and was returning for landing. The pilot of N27KJ had just entered the aerobatic…