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 20170720014709IColumbia Aircraft Mfg LC42-550FG · Chesterfield, VA^Mr. Joseph hoyle^ was conducting a rental checkout for ^stuart cox^. Several successful landings took place prior to the incident. On the final landing, ^Mr. Cox^ was told twice by ^Mr. Hoyle^ that he was low and finally that he was low and slow. ^mr hoyle^…Incident 20170720014699IPiper PA-24-250 · Paim Springs, CAThe aircraft departed vny going to psp. Aircraft was landing runway 13R. During the rollout, the main landing gear collapsed followed by the nose gear soon after. The propeller struck the ground curling the last 10 to 12 inched of the tips. One person on…Accident 20170720012559ARobinson Helicopter R44 II · Logan, IAThe pilot was operating a helicopter, N192E, on the morning of July 20th 2017. He was performing aerial application in a field about 3 miles away from Logan, IA. After performing 2 reconnaissance passes, including an orbit around the target application area…Incident 20170720011919ICessna 175A · Bozeman, MTThe aircraft departed spokane (kgeg) on a direct flight to Bozeman (kbzn). There were two people on board, both pilots. In spokane they added 7.5 gallons on each side, bringing the total fuel on board to approximately 46 gallons. This was verified by drip…Accident 20170720010729ACessna 152 · Taramac, FLAircraft experienced complete power loss during practice manuevers with student. CFI elected to land on a dirt road adjacent to the everglades. Upon landing aircraft flipped and came to rest inverted in the everglades adjacent to the road.Accident 20170720009979ACanion Michael W Zodiac 601XL · Grady, AROn July 20, 2017, at approximately 1500 CDT, a zodiac 601 xl, registered as N577M, landed in a corn field near Grady, AR due to complete electrical system/engine failure. Visual meteorological conditions prevailed at the time and a VFR flight plan was not…Accident 20170720007959AAeronca 11AC · Gilbert, SCOn 7/20/2017 at approximately 20:15 EDT, aircraft Aeronca 11AC, N3154E operating part 91 VFR was performing a landing on runway 9 at Whiteplains Airport (SC99) located in Gilbert SC. The aircraft landed and swerved left off the runway striking a wind sock…Accident 20170719018609ACessna 172N · Factoryville, PAThe pilot stated that he landed down wind and should have performed a go around. The aircraft did not have full flaps deployed. The aircraft landed with excessive speed and ran off the end of the runway.Incident 20170719014669ICirrus Design SR22 · Brenham, TXReceived a report of a aircraft NLG collapse after landing. The aircraft had performed numerous touch and goes, both at ktme and 11R, with noticable wheel shimmy, prior to the fixed gear aircraft experiencing the collapse of the NLG. Inspection of the…Incident 20170719014629ICessna 172S · San Jose, CAAircraft touched down on runway 32 with both main wheels. And the aircraft yawned to left. The aircraft exited the runway and stopped on the lawn in between run way 32 and taxi way y.Incident 20170719014619IRobinson Helicopter R44 II · Babylon, NYHelicopter in cruise --14OOFT AGL@110KTS when PIC and pax heard loud bang and noted noticeable change in engine sound. RPM immediately became erratic and engine RPM exceeded rotor RPM. PIC attempted to manage RPM but was unsuccessful and as rotor RPM began to…Incident 20170719014609ICessna P206 · North Belleport, NYUpon departure from runway 24 at khwv the pilot in commmand (PIC) noticed that power changes with the throttle were no longer effective. Shortly thereafter about 3-4 miles from the airport the engine slowly started to decrease power. The PIC began to return…Incident 20170719014599IMcdonnell Douglas MD-88 · Baltimore, MDAt approximately 2230 on 07/19/2017 in Baltimore,MD(bwi) airport: delta airline aircraft, N940DL, MD-88, was parked at gate D-25. Aircraft was remaining overnight and not intended for flight, no passengers or crew onboard. The aircraft was struck by fuel…Accident 20170719012549AEmbraer S A ERJ170-200LR · Msp, MNOn July 19, 2017, about 2245 central standard time (CST) (0345Z), republic airline, inc., flight 4678, an Embraer 175, N427YX, experienced severe turbulence during approach resulting in serious injuries to a flight attendant. The flight attendant was in the…Accident 20170719012539AMichael Dean Grissom Grissom Pober Pixie · Louisburg, NCPilot was on a normal approach to landing at Ball Airport. He was setting up to land on the grass portion of the runway prior to the pavement for runway 36. He was coming in at approach speed of 60 mph. He landed short and hard of the designated grass landing…Accident 20170719012529AAircraft Mfg & Dvlpmt CH601XLI Slsa · Towanda, PAPilot was conducting traffic patterns at airport. After a 'touch and go', and during climb out, he transmitted on the radio that he was experiencing an "in flight emergency" (without description) and was "returning to the airport". Witnesses described the…Accident 20170719012519APiper PA-28-151 · New Market, VADuring landing rollout aircraft hit a 200 hundred pound deer. Aircraft was damaged on left wing leading edge from the fuselage outboard approximately 30 inches and ripped the skin back to the spar. Aircraft was towed to the ramp. None of the 9…Accident 20170719010739AGrumman G-164 · Marydel, DEThe aircraft was completing the first pass of third flight, appeared to be at a normal speed and altitude for a standard spraying pass when it struck power lines. GPS stopped tracking at conclusion of final spray pass before aircraft came to a stop. Aircraft…Accident 20170719009939AEnstrom F-28C · Ontario, CAThe pilot was on final approach to Chino Airport (cno). The pilot established a 100 foot descent rate and noticed the engine RPM was slightly above 2900 rpm's. the pilot reduced the throttle slightly to bring the engine rpm's back to 2900 RPM and keep the…Accident 20170719007229AWeatherly 620 · Southhampton, NJOn 7/19/17 at approximately 1845 the pilot initiated takeoff roll. Approximately 10-20 feet above the runway at approximately 80 mph. The pilot felt a drastic decrease in performannce. The pilot emergency dumped the hopper load. The pilot felt no increase in…Incident 20170718014589IBeech B200 · Santa Teresa, NMAfter leaving the hangar and taxiing on the ramp toward the departure end of the airport, the aircraft's right wing tip hit a parked vehicle.Incident 20170718014579ICessna 182K · Linden, NJN3152Q was returning to kldj from kfwn on the afternoon of July 18, 2017 at approximately 14:00 local. Upon arrival to the Linden area the AWOS was reporting winds from 140 degrees at 9 knots. The pilot decided to join the left hand pattern for runway 9. He…Accident 20170718012509APiper PA-28R-201 · Bowling Green, OHThe pilot was receiving instruction toward his initial flight instructor rating. The flight started with practice of maneuvers in the practice area and ended with take off and landings in the traffic pattern. On the final landing the pilot was demonstrating a…Accident 20170718012499APiper PA-22-160 · Breckenridge, MIOn July 18, 2017 at approximately 18:20 eastern daylight time, a Piper PA-22-160 aircraft, N9807D, registered to and operated by a commercial pilot, received substantial damage when it overturned during landing on the westbound runway of a private grass…Incident 20170718012319IPerry John S Aerocanard · Cresent City, FLThe PIC stated that on landing rollout, his foot sliped off the right rudder pedal. The aircraft then started to veer left, the PIC tried to gain control. He quickly applied right brake and over corrected the aircraft. The aircraft then departed the runway to…Accident 20170718010749ASalerno Kenneth G JR Kitfox Series 7 · Owyhee Reservoi, ORBrief description of circumstances surrounding occurrence taken from block 5 of the 8020-9: Aircraft crashed while attempting to depart 28U. Pilot over corrected and the aircraft rolled. Pilot's narrative history (description)of flight as reported on page 9…Accident 20170718009239APiper PA-25-235 · Foster, NEA witnessed stated that the pilot made two passes over the field. On the second pass heading south, the aircraft was straight and level, pulled up over a line of trees and did a right turn. The aircraft continued in a right turn without gaining additional…Accident 20170718009119AAir Tractor AT-802 · Reyno, AROn July 18, 2017 at approximately 1730 CDT, N816FF a Air Tractor 802A aircraft, registered to Air Tractor, inc. operated by a commercial pilot landed in a field approximately 3.5 miles west of Reyno, AR while performing aerial application from a remote…Accident 20170718009109AD & K Baby Belle · Spartanburg, SCStudent helicopter pilot taxiing from grassy area adjacent to rwy 23 to grassy area adjacent to rwy 05. Pilot had a loss of directional control which was partially regained but his subsequent landing was hard and resulted in aircraft leaning to the right and…Accident 20170717015479ACostruzioni P2008 · Lone Rock, WIOn July 17, 2017 at 2000 CST, a Tecnam P2008 N445X piloted by student pilot ^Mr. Michael porter^, was damaged after touchdown on runway 9 at tri-county airport in Lone Rock WI. The pilot reported seeing an animal cross in front of the approach end of the…Accident 20170717015449ACessna 195B · Leavenworth, KSThe aircraft departed goodland, KS (gld) with Leavenworth, KS (flv) as the final destination. During landing on runway 16, the tail wheel touched down and the pilot noticed the aircraft was heading toward the right side of the runway. The pilot stated that he…Incident 20170717014569IDiamond Aircraft Ind DA20-C1 · Fort Lauderdale, FLAt approximately 0900 hrs. On 7/17/17 [privacy data omitted] (instructor) and [privacy data omitted] (student pilot) were attempting to takeoff from fxe runway 9. Pilot 2 stated ?shortly after rotation while still above the runway, an alarming vibration was…Accident 20170717009929AEvolution 19 LC Lancair Evolution · Mesa, AZOn July 17, 2017 at approximately 1652 MST, N571JM, a Lancair Evolution, crashed on base to final turn to runway 22L at Falcon Field. The pilot and sole passenger were killed. The aircraft was consumed by post impact fire. Weather was VFR. The pilot had…Accident 20170716024612ASpani Wayne M Starduster TOO SA300 · San Diego, CAStarduster N506WS was taxing on taxiway c to the run up area for rwy 23. Ahead of him was N5396E. N5396E was waiting on taxiway c for his turn in the run up area as multiple aircraft were ahead of him. As N5396E waited, N506WS struck this aircraft from behind…Accident 20170716023999ANorth American/Aero Classics P-51D · Cummings, KSFollowing departure from the airport, basic radar data indicates numerous changes in altitude and direction consistent with intentional aircraft maneuvers. These radar indications also indicate that the aircraft overflew the airport several times, then…Accident 20170716021209APerner/Pitts S1S · Brenham, TXAfter receiving 3.4 hrs of transition training, which included aerobatics the pilot puchased the accident aircraft and proceded to ferry it from phonix Arizona to stewart Florida. While enroute from austin to an airport northeast of houston the pilot noted…Accident 20170716014559AAeroprakt A-20 Vista Cruiser · Shirley, NYEngine stoped on final approach to Brookhaven calabro airport, Shirley, NY after aircraft experienced a strong downdraft sink at approximately 700 feet.Incident 20170716014549ISchempp-Hirth Ventus B/16.6 · Truckee, CAAirman reported a hard landing in his sailplane resulting in minor damage. Classified as an incident. A reveiw of airman and aircraft records found no discrepancies.Incident 20170716014479ICessna P210N · Napa, CAP210N is diverted from dvo to apc due to a nose gear indication light. Cpa activated at 1840 z N210SL performed a low approach to inspect the nose gear. Verified the nose did not appear down. Aircraft landed with nose wheel up. No injuries, minimal damage.…Incident 20170716014469IPiper PA-32R-300 · Cahokia, ILIncident pilot stated he discovered damage to the blade tips of the propeller after completing a two-hour flight with an intermediate stop at a second airport (ksik). Pilot states that he has no idea how the blade tips were damaged. Inspectors examined the…Incident 20170716014459IKennedy Thomas M Cozy Mark IV · Concord, CAConcord, CA (ccr): N787T, amateur home built cozy, nose gear collapsed while taxiing onto runway 32R for departure. Nose gear would not extend; airport ops helped remove/tow the aircraft off the runway. POB: 2, injuries: none, damage: minorAccident 20170716012429ACessna R172K · Naples, MEDuring landing on brandy pond, the aircraft impacted the water in a flat attitude and bounced multiple times. Normal water landing conditions were present, and glassy water was not a factor. On the third bounce the aircraft rolled to the right while on the…Incident 20170716011809IBell 407 · Dubois, WYWhile repositioning the EMS helicopter during a medical emergency to a new landing zone the helicopter?s tail rotor struck a rock. The pilot continued to a new location a few feet away and landed the aircraft. During the failed attempt the pilot had a ground…Accident 20170716009099ACessna TU206G · Albuquerque, NMOn July 16 2017 at 1510 MDT, a Cessna 206, N166Z registered to usda forest service fire & aviation porpoised on landing at Albuquerque international sunport, Albuquerque, new Mexico while on a repositioning flight. Visual meteorological conditions prevailed…Accident 20170715024539AEndler Alfred F Glasair SH2 · Colorado Spring, COOn JULY15,2017 [privacy data omitted] and [privacy data omitted] attempted to takeoff at meadow lake airport in a glassair ii, N181AL. During the takeoff attempt [privacy data omitted] lost control of the aircraft . The aircraft departed the runway, travel…Accident 20170715020599ACessna A185F · Wasilla, AKAircraft departed lake louise (13S) on straight floats with a destination of campbell lake (3C3). One hour into flight at 1600' altitude just south of palmer, AK, engine started to sputter. Pilot maneuvered a/c to be directly over hayfield flats recreational…Incident 20170715014449IEngineering & Research Ercoupe 415-C · Tipton, IAOn July 15, 2017 while on final approach at the Tipton, IA airport there was a crosswind, the aircraft being flown does not have rudder pedals and requires the airman to land in a "crabbed" configuration. Upon touchdown the aircraft nose wheel began to…Incident 20170715014159ICirrus Design SR22T · Kansas City, MOShortly after normal touchdown at kmkc, the nose landing gear leg collapsed. The pilot described the departure and flight from kden to kmkc as uneventful. The pilot stated that on touchdown on rwy 19, the nose of the aircraft dropped, resulting in prop…Incident 20170715014149ICessna T188C · Monticello, ILThe pilot was providing aerial appication services for land owner in Monticello, Illinois when he expirenced total power loss and engine failure. Pilot was able to land the aircraft in a corn field with no injury and minimal damage sustained to aircraft.Incident 20170715014139ICessna S550 · La Porte, TXPilot landed at T41 after a thunderstorm had passed through the area. The winds had changed and he decided to circle to land on rwy 12 after shooting an approach to rwy 30. The runway was very wet and the pilot reported little to no braking action. The…