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 20140704013649IPiper PA-12 · N. Myrtle Beach, SCOn July 4, 2014 at approximately 1330, a parasail was struck by an aircraft banner in the vicinity of 17th street south in north Myrtle Beach, SC. The parasail had two occupants--two boys ages 12 and 14. The boys were not injured and were landed safely by the…Accident 20140704011819ASlaughter Mike CH601-HDS · Frankston, TXOn the morning of July 4, 2014, the day of the accident, pilot and passneger flew N4263 from their home base of aero estates (T25) to attend a fly-in event at wisener field (3F9) near mineola, TX. At approximately 13:15 CDT. N4263 departed 3F9, to aero…Incident 20140704011409IStephens William E Quicksilver · Columbia, ILOn July 4, 2014 at about 03:00 pm [privacy data omitted] made a power-off landing due to engine failure. [privacy data omitted] Was operating a Quicksilver mxl ii with one other person onboard. [privacy data omitted] Stated the engine RPM was decaying, he…Accident 20140704011209ACentrair 101A · Nephi, UTPilot departed Nephi Utah (U14) for a local glider flight. The pilot stated that he had turned final being lined up with runway 17. He then decided to line up and land on what he thought was a grass strip west of that runway. He had actually lined up on a…Accident 20140704009969ACessna 170B · Tomball, TXI arrived on scene and observed a Cessna CE-170B, N170CC on its top in a ditch filled with water about 35 feet from the right edge of runway 17 right, 1500 feet from the approach end. There multiple fire and ploice vehicles on the scene. Texas highway patrol…Accident 20140704009319ANorth American/Aero Classics P-51D · Durango, COThe instructor has limited experience in the P-51 aircraft. The owner recently sent the instructor to training on the P-51 in order to return and teach him how to fly the aircraft. The owner has limited experience in flying based on receiving his private…Accident 20140703013639APiper PA-24-250 · Monroeville, ALN5923P departed keet on an IFR flight plan to kmvc for the purpose of flight training on the use of a newly installed garmin 430 GPS. The CFI, who was occupying the right seat, was acting as pilot-in-command since the aircraft owner/private pilot did not have…Accident 20140703013629ACessna 336 · Mobile, ALWhile conducting a mosquito spray mission at an altitude of 100 feet AGL, the rear engine began to run rough and sputter. Pilot switched from the main fuel tank to the aux tank for the rear engine and turned on the boost pump. No change was noted. Pilot…Accident 20140703011179APiper PA-25-235 · Rhinelander, WIJuly 3, 2014 a Piper PA25-235 registration N8730L was conducting application operations under 14 CFR part 137 near sugarcamp Wisconsin. The aircraft made a unscheduled landing in a potato field and came to rest nosed over then upside down. The pilot was the…Incident 20140703010829IAero SP Z O O AT-4 LSA · Denver, COOn July 03, 2014 about 13:00 MDT a gobosh AT4-015, N1277K registered to skyraider aviation inc. impacted the ground 400 feet west of runway 35 at Front Range Airport (ftg), watkins, CO while on a training flight. Visual meteorological conditions prevailed at…Accident 20140703010559AAmerican Eurocopter AS350B3E · Fallon, NVDuring a pinnacle approach with a 100 ' long line, the pilot stated that the aircraft stated to rotate rapidly to the left. The pilot was unable to regain control and impacted the ground shortly thereafter.Incident 20140703010179ICessna 172S · Renton, WAPilot doing touch and goes at the Renton Airport, upon contact with the runway, airplane veered to the left,pilot attempted to correct back to the right, but was unsuccessfull utilizing rudder and brakes,airplane slid into grass area striking airport…Accident 20140703010129ABell 47G-3B-2 · Gaston, ORAfter lifting off, spray bucket's RH hydraulic hose snagged the RH fwd skid at about 5 ft off ground. Helicopter attitude shifted fwd and helicopter moved fwd over bucket. Pilot increased lift and power but was at max aft cyclic and could not stop fwd…Incident 20140703010069IAirbus A319-111 · Cleveland, OHAircraft was being marshalled in to gate A9 when left engine inlet cowl struck the jet bridge. Jet bridge was parked outside of the limitation box that was painted on the ramp.Accident 20140702017849APiper PA-28-140 · Granbury, TXN9898W departed rwy 14 Granbury regional airport (kgdj). On climb out at approximately 500 feet AGL the aircraft began to lose engine power. Student on the controls transfered control to instructor. Instructor attempted to return to the airport, but didn't…Accident 20140702017299ARobinson Helicopter R44 · Olathe, KSHelicopter parked facing the north on a downhill slope. Wind was out of the north at 15 gusting to 23 mph. During shutdown sequence, as he released the rotor brake, the helicopter sustained substantial damage when one blade contacted the tailboom.Accident 20140702013979ACessna 177B · Grass Valley, CAAircraft ran off runway and into a ditch during touch and go landings when pilots foot became lodged in the rudder pedals. This pilot had not flown in the last 11 months and was completing his 3rd takeoff and landing for currency when the incident occurred.…Accident 20140702013019ARockwell International 500-S · Wilcox, AZPilot landed on runway 3 unaware of a quartering right tail wind estimated at 15 kt. The pilot reported that he had called the Wilcox FBO before landing and was told that the winds were light and variable, but because it was dusk he could not see the…Accident 20140702012579ACessna 210L · Las Vegas, NMPilot attempted to land on closed runway 32 at lvs. After seeing men and equipment on the runway, PIC attempted a go-around. Aircraft unable to go-around and aircraft crashed in a field.Accident 20140702012539APiper PA-30 · Harrison, AROn July 2, 2014, at 0810 CST, a Piper twin commanche PA-30, N7726Y, an unregistered aircraft, crashed at Boone County Airport, Harrison, Arkansas, while on a repositioning flight. Visual meteoroligical conditions prevailed at the time and it is unknown if a…Incident 20140702010929ICessna 152 · Lewes, DEDeparted ocean city, MD (oxb) and was flying north along the coast when approaching Lewes, DE at 1500' aircraft started experiencing engine problems. Applied carburetor heat, adjusted the mixture, and changed magnetos. After switching magnetos the engine ran…Accident 20140702010889ANorthwing Design Apache Sport · Omro, WIAccording to eye witnesses the pilot departed wilke field located two miles east of the crash scene at 6:00PM local time to try out a new wing that the pilot had installed earlier. This was the very first flight using the new wing. The eye witness stated that…Accident 20140702010579APiper PA-12 · Anchorage, AKAircraft attempted takeoff from runway 25 at k intersection, gained approximately 100-150' in a steep nose-up pitch attitude, then abruptly pitched over and impacted terrain approximately 30-40' to the right of runway 25, even with the beginning of the 1000'…Accident 20140702010439AWiley Kenneth Kitfox IV · Sprague, WAPilot stated he was taxiing the aircraft and became airborne. He made several attempts at landing and flew to his sisters residence to attempt to land. On the approach he struck power transmission lines that caused the aircraft to crash.Incident 20140702010059ICirrus Design SR22T · Ashland, OHDuring power off landing aircraft left wing struck runway minor damage to wing and pitot tube.Incident 20140701013819IPiper PA-28-180 · Riverside, CAJust after rotation on takeoff engine sputtered/cut out 2 times. Pilot landed aircraft 1,00O ft down the runwayAccident 20140701012909ABeech A36 · San Antonio, TXAircraft inbound from houston, Texas to San Antonio, Texas. Upon gear extension left main landing gear failed to extend. After several attempts to recycle the gear and being unsucessful with emergency gear extension procedure, pilot elected to execute a gear…Incident 20140701012049IBeech G35 · New Bern, NCDuring flight the pilots left rudder pedal collapsed to the floor of the aircraft. Upon landing the aircraft had full left rudder deflection and no left hand braking which resulted in the aircraft veering off the runway and into the grass where it spun and…Accident 20140701011609AAir Tractor AT-602 · Clarksdale, MSApplicator was applying fertilizer. Aircraft impacted the ground during a turn. Unidentified cause of accidentAccident 20140701010849ACessna 172R · Joplin, MOPilot was landing (touch and go) at kjln. On the first attempt, at approximately 100 feet AGL, the pilot stated that the engine began to "grumble/cut in and out". Pilot immediately cut power and put the aircraft back on the ground. The aircraft departed the…Incident 20140701010569IDehavilland DHC-2 MK.I · Anchorage, AKThe aircraft owner started the engine and selected the fuel tank with the least amount of fuel in it, for the purpose of warming the engine prior to take off. The incident airman then boarded the aircraft, and completed the before take off check list but…Accident 20140701009339AJones Herbert M Hatz CB1 · Hysham, MTAircraft was in the landing phase of runway 25, as the aircraft touched down the pilot stated that his right foot may have come into contact with the right heel brake pedal. The aircraft departed off to the right side of the paved runway came into contact…Incident 20140701009259IBeech 35-A33 · Burlington, WA2Nd pilot was receiving training check out for insurance purposes from pilot #1. Pilot 2 had completed 2 touch & go landings on runway 29 at Skagit Regional Airport (bvs). After the second touch & go, on the upwind leg of the traffic pattern pilot 2 asked if…Incident 20140630013619ICessna 172R · Daytona Beach, FLDuring a touch and go landing. Engine stop producing power and pilot decided to use the departure end of the run way for the landing no damage on the aircraft, waiting for final logbook entires for work performed to return aircraft to service .Accident 20140630012869AHarrisonburg, LAAircraft was low over lake and made left turn (west) to fly over property, the aircraft contacted the trees and hit the ground. Pilot had no certificates and was friend of aircraft owner.Accident 20140630011189AHoffman David K Hoffman BMW Airtrike · Payette, IDThe aircraft owner needed to reposition his aircraft from caldwell airport (eul) to hubler field (pvt). While enroute to hubler field the aircraft owner decided to do some touch and go's at Payette Municipal Airport (S75). On his first attempt his left wing…Incident 20140630011089ICessna 337G · Oneonta, ALOn June 30, 2014 the certificated private pilot of aircraft N72446 was enroute from albertville, AL (8A0) to Oneonta, AL (20A). The pilot stated he made a normal approach and went through his check list and the landing gear light was green and no warning horn…Accident 20140630010429APiper PA-28-235 · Georgetown, COOn June 30,2014 at approximately 0840 Piper aircraft PA-28-235 lost control over loveland pass ski area. Aircraft impacted ground and was destroyed. Three fatalities recorded.Incident 20140630009889ICessna 340A · Perryton, TXOn July 1, 2014, N381JP, a CE-340A aircraft lost power and executed an emergency landing on a road near Perryton municipal airport in Perryton, TX. The pilot and three passengers were aboard the aircraft, and there were no injuries.Incident 20140630009539IPiper PA-23-250 · Twin Bridges, MTConstruction activities were underway at the airport. A NOTAM for the closure of asphalt rnwy 17/35 was issued 0800 6/30/14 till 10/31/14 AT1659. Construction cones had been placed across the taxi way at a point prior to where the taxiway terminates at a…Incident 20140630009249IMooney M20M · West Lafayette, INOn June 30, 2014 at approximately 15:45 local time, N9149P, a Mooney M-20-M aircraft, with serial number 27-0108, sustained minor damage when it failed to develop takeoff power, for unknown reasons, while departing runway 23 at the purdue university airport,…Accident 20140629023669ACzech Sport Piper Sport · Peachtree City, GAOn climbout, witnesses stated the a/c wasn't climbing sufficiently to clear trees ahead; a/c stalled and crashed nose first.Incident 20140629012889ICessna 421B · Oklahoma City, OKPilot declared an emergency due to the right engine failure. Pilot reported, he was east of kingfisher, OK, at 16K? When the right hand engine lost oil pressure. ATC directed him to will rogers?s airport (okc), he request wiley post (pwa) but when the…Incident 20140629012069ICessna 172N · Plymouth, MADuring power off stall demonstration, the plane was slowed to below vfe, the flaps were extended to full (40 deg). A stall was induced after which the nose was lowered and full power was applied, the flaps were retracted. As soon as the flaps began to…Accident 20140629012059AWaco UPF-7 · Bealton, VAWhile flying in formation at the flying circus aerodrome in Bealton, VA, a Waco UPF-7 (NC32162) made a forced landing in an open field after the engine quit. The aircraft departed the open field and impacted several pine trees at the edge of the field. The…Incident 20140629010879IBoeing 737-724 · Wichita, KSDuring cruise flight level at FL400 the pilots received a door open light indication in the cockpit. The cabin crew simultaneously heard a loud pop and hissing noise. The L2(left rear) door emergency evacuation slide inflated. Cabin crew notified the captain…Accident 20140629010839ACessna 182Q · Big Creek, IDThe pilot was landing at Big Creek airstrip (U60) for a fly in breakfast. He was the last aircraft in a party of six. The downwind leg of the landing approach is flown behind a ridge and the airstrip cannot be seen when on downwind. The pilot turned an…Accident 20140629010689ACessna 182A · Geneseo, ILPilot was descending after releasing 2 parachute jumpers. While descending, the pilot stated the engine was "acting up". She checked the fuel gauges which read 1/4. Prior to the flights, the owner of the aircraft had told her there could be trapped air in the…Accident 20140629010219AAerospatiale AS350B2 · Dietrich, IDHelicopter departed the twin falls, Idaho airport (twf) at approximately 1640 local time with the pilot and two passengers for a photo fight near rexburg, Idaho. About 15 minutes into the flight, in cruise, at 800 AGL, the passengers report that the pilot…Accident 20140629009719ACessna 172S · Orlando, FLWhile taxing back to aircfraft parking ramp. A rain storm came in and a strong gust of wind flipped over the aircraft on taxiway alpha . No injuries were suffered. The aircraft is a total loss.