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 20180810010579ARobinson Helicopter R22 Beta · Ocean City, NJOn August 10, 2018, at Ocean City Municipal Airport, NJ, over a marsh area west and adjacent to runway 6, a CFI was performing hover training wih a student in a Robinson R22 helcopter, at about 3-feet from the ground. During the sequence of establishing and…Incident 20180809018839IPiper PA-44-180 · Sanford, FL08/09/2018- CONN681- N164CA reported a nose gear problem and landed on runway 27R with the nose gear stuck in the up position.Accident 20180809014179APiper/Cub Crafters PA-18-150 · Raton, NMOn August 09, 2018, at 1125 MDT, a Piper cub crafters PA-18-150, N104CC, registered to doss aviation, inc., of Colorado springs, CO, ground looped on landing at Raton municipal airport, on runway 25 at Raton, new Mexico (krtn), while on a personal flight.…Accident 20180809010729ADeal Lawrence KITFOX-SUPER Sport · Freehold, NYDuring level flight, the pilot noticed that the engine was using more fuel than planned and attemped a precautionary landing for fuel on a wet field, the main gear sunk into the wet ground, and came to rest on it's back with minor damage.Accident 20180809010569AMaule MX-7-180A · Nelchina, AKStakeholder stated the following ?He is familiar with attempted landing area ?Weather - clear and no wind ?Aircraft has 31-inch tires installed ?Approach was 5-7 mph fast ?Believes flaps were fully extended ?Stuck 3 point landing but due to the landing speed…Accident 20180809010559ACessna R182 · Florence, SCOn Thursday August 09, 2018, at approximately 1:12 pm local time, a Cessna R182, with registration number N1693R veered off the side of the runway at Florence regional airport, in Florence, SC 29506. The aircraft called local ATC on the guard frequency and…Accident 20180809010529APiper PA-28-161 · Merritt Island, FLThe student pilot was performing solo touch and go landings on runway 29 on his 3rd solo flight. He reported that he had obsrvd a white bird heading toward the aircraft as he was about to flare the aircraft on the 4th t&g. the pilot attempted to avoid the…Accident 20180809010519AAirgyro Tercel · Spanish Fork, UTStudent pilot was to fly his first solo flight. He met with his CFI prior to the flight and discussed weather and the plan for the flight the was to occur. The student pilot lined up on the runway advanced the throttle to full open and began accelerating…Incident 20180808023859IBoeing 737 · Los Angeles, CAACA799, B38M, cyyz-klax, reported striking a bird at 3,000 ft. while outside of hunda on ILS RY25L approach (10 mile final), no damage reported.Incident 20180808018829IWard Tom A20 Vista Cruiser SC · Animas, COPIC was landing/practicing with different flap settings. Landed and drifted left, applied full right rudder, added power for rudder effectiveness and then needed full left rudder. Started braking to stop and exited the runway.Accident 20180808015129ACessna 172R · Greeley, COOn August 8, 2018, at approximately 2000 hours (MST), N20JA, a Cessna c- 172, Sustained substantial damage on a touch and go at Greeley-Weld County (kgxy), CO. Weather at time was visual metrological condition (VMC). There were two occupants on board with no…Incident 20180808015119IEmbraer Executive EMB-500 · Pueblo, COOn August 8, 2018, at approximately 1701 hours (MST), N670AS, a Embraer Executive Aircraft Inc EMB-500, sustained minor damage on an emergency landing due to a blown tire on takeoff roll at Pueblo Memorial Airport (kpub). Weather at time was visual…Accident 20180808015109ACessna T337G · Lewiston, IDGear would not come down. Pilot landed gear up without injuries or property damage. Main gear "clamshell" gear door actuator retaining bushing circlips had released the bushing, which slid out of the hydraulic cylinder on both sides, releasing hydraulic fluid…Accident 20180808010609AHughes 369D · Honolulu, HIOn August 8, 2018, about 0920 hawaii‐aleutian standard time, a Hughes 369D helicopter, N369MH, experienced a significant inflight vibration event, which resulted in the pilot executing an emergencylanding to a school field in Honolulu, Hawaii. The…Accident 20180807010599ACessna 207F · Iliamna, AKTook-off from Iliamna Airport runway 35, left down wind departure. Two minutes after take off, experienced engine failure, turned back towards airport and landed one mile from end of runway 35 into the tundra causing substantial damage to the aircraft. No…Accident 20180807010589ABell 206B · Mesa, WAPilot lifted off from loading area with 60 gallons water and 25 gallons of fuel. For cleanout run. Accelerated to 50 mph and ended run and reversed run ,in the left peddle check,the pilot settled with power, due to lack of forward speed, and timely control…Incident 20180807010369IPiper PA-28-181 · Mesa, AZAirman was performing his first cross country flight in accordance with the flight silibus. Upon return to Falcon Field (ffz). On approach an aircraft asked for a wind check. Ffz tower responded with winds 310 deg at 13 knots. Tower again responded with winds…Incident 20180807010359IEmbraer EMB-145XR · New York City, NYAt approximately 1430 local time on August 7, 2018 trans states airlines flight lof 4697 enroute from Washington dulles international airport, Washington, DC (iad) to theodore francis green state airport, providence, rhode island (pvd) encountered smoke in…Accident 20180806014169AWalter C Smythe Tango XR · Galion, OHPilot was flying the aircraft from brunswick Maine to el cohon California. During the first approach at Galion Municipal Airport the aircraft was high and fast. The pilot elected to execute a go- around. During the second approach to landing the aircraft…Incident 20180806010349IPiper PA-44-180 · Trenton, NJ8/6/2018 Pilot on multi-engine training flight departed ttn with kblm as destination. When entering downwind leg at kblm, gear down checklist started. When gear handle placed in the down position, the left main gear (down and locked) indicator failed to…Accident 20180806010339ACessna 172M · Crystal River, FLOn Monday, August 6, 2018, the pilot rented a 1975 Cessna 172M N9608H from a fixed base operator located at Crystal River, FL (kcgc). At approximately 1030, the pilot had a hard landing resulting in a propeller strike in N9608H at kcgc causing substantial…Accident 20180806010329ACessna 120 · Pomona, MOThe accident occurred August 6, 2018, at approximately 10:00 local CDT near Pomona , Missouri, and the aircraft was carrying the pilot and one passenger at the time of the accident no injuries reported. The location of the accident site was approximately 1…Accident 20180806010319ACessna A188B · Hughesville, MOWhile maneuvering during aerial application, the aircraft's engine lost power. The pilot initiated an emergency descent into a field. The aircraft impacted trees short of the field and came to rest in a clearing. A post-impact fire consumed much of the…Accident 20180805010179ASchweizer SGS 2-33A · Churchville, MDOn August 5, 2018 at approximately 1500 EST, the pilot and a tow pilot attempted a glider tow operation at aiport 0W3. The glider pilot stated that normal operation would be to use the grass runway 01/19, but due to the recent high amounts of rain, that…Accident 20180805010169ACessna 185 · Lovelock, NVThe pilot departed 3U2 with 39.9 gallons of fuel onboard. The pilot planned 2.5 hours to his next fuel stop at lol with a fuel burn of 10.5 to 11 gallons per hour. The pilot stated when enroute he encountered light haze, turbulence and unforecasted headwinds.…Incident 20180805010139IBoeing 747-446 · Bwi, MDOn 5 August 2018 N465MC was operating as GTI8643, a ferry flight from Baltimore, Maryland (Bwi) to houston, Texas (iah). There were 16 dead-heading Flight attendants and two (2) flight crew. As the captain applied power for takeoff, the crew received a stab…Accident 20180805010129AJensen Paul G Savannah · Fairfield, UTAccording to the pilot, ?I was descending for a landing when my plane lost lift and began to stall. I immediately applied full throttle for maximum power, but the plane continued to fall. I continued to apply full power, but the plane did not recover in time…Accident 20180805010119ABellanca 7GCBC · Wiley, COOn August 5, 2018 at approximately 0910 mountain daylight time, a single engine Bellanca citabria, N90990 was substantially damaged upon impact. During the approach to his private runway the pilot thought he had enough clearance to avoid the guide wires for…Accident 20180805007549ACessna 414 · Costa Mesa, CAFixed wing accident Registration:N727RP Make:1973 Cessna Model:414 chancellor Serial number: 0385 On August 5, 2018, at approximately 1929 UTC (coordinated universal time), a Cessna model 414, U.S. Registered aircraft; N727RP was destroyed when it impacted…Accident 20180804010069ADehavilland DHC-2 MK. I(L20A) · Denali, AKOn August 4, 2018 at approx 1700L, K2 aviation N323KT, a DHC-2 mki 'beaver' departed patk on a CFR part 135 flightseeing trip in and around Denali national park with five persons on board. At approx 1755L, K2 dispatch received a ELT alert and satellite phone…Incident 20180804010039IRockwell International NA-265-65 · Eagle, COOn August 4, 2018 at approximately 1230 mountain daylight time, a Rockwell saberliner N770MD, experienced hydraulic failure during approach. The pilots activated the emergency brakes and landed the aircraft without incident. The hydraulic system appeared to…Accident 20180804010009AKlingmuller Lothar M L RV-6A · Greeley, COFlight departed front range airport (ftg) for Greeley, CO (gxy) at approximately 10:50 am local time on 8/4/2018. The builder of the aircraft had put the engine instruments on the FAR left so that one could not solo the aircraft easily from the right seat.…Accident 20180804009979AAmerican Champion 8GCBC · Foley, ALExperienced ground crew witness observed aircraft pick up a large banner and climb steeply in a normal manner to raise banner from the ground. At approximately 300 feet AGL, at the top of the climb and as the banner was fully lifted off the ground, the…Accident 20180804009969ABeech J35 · Knox, INThe pilot of N533JW was on final approach to runway 18 at starke county airport in Knox, Indiana (koxi). The pilot stated that he reduced the power to idle while on final approach. The pilot stated that, shortly thereafter, he was getting too low on approach…Accident 20180804009959AExtra Flugzeugbau EA-400 · Ponca City, OKOn August 4, 2018, about 10:40 central daylight time, an Extra Flugzeugbau Gmbh, a single engine airplane, Extra EA-400, sustained substantial damage following loss of engine power / and or control in flight and subsequent impact with the ground in Ponca…Accident 20180804009939ABellanca 7GCAA · Lakewood, NJOn 08/04/2018 a banner aircraft, N87000 dropped a banner (panel) in the designated drop zone at Lakewood Airport (N12). According to the pilot, the throttle was brought to idle, as the aircraft descended for its drop. The banner was released and full throttle…Accident 20180804009919ABurke Raymond J JR S-7S · Tyonek, AKAircraft landed at an unimproved airstrip that is about 900' long with 30' tall trees at either end in the morning. Airman departed in the afternoon when temp had risen to approx. 73 degrees f. aircraft was almost at gross weight for takeoff. Aircraft took…Accident 20180804009909ACessna 140A · Lumberton, NJAirplane was landing with a slight, variable, right crosswind, bounced twice then settled down on main wheels. With tailwheel still off ground, it drifted off of the left side of the runway into the grass between the runway and parallel taxiway. Pilot saw…Accident 20180804009879ACessna 172H · Sallisaw, OKThe student was conducting a solo flight at kjsv. During the fourth landing the student was on roll out when he lost control and went off the runway on the east side. The airplane came to rest in a ditch.Accident 20180804009869AWSK PZL Mielec M-18A · Dansville, NYPilot stated that while cresting a hill to begin his aerial application the aircraft descended rapidly. He attempted to pull up but the aircraft struck the corn and decelerated. The aircraft impacted terrain and flipped over and came to a stop inverted. The…Accident 20180804006739ACessna 172M · Dowagiac, MIOn August 4, 2018 at 7:11 pm eastern daylight time, a Cessna 172M aircraft, N8994V, registered to an association and operated by a private pilot, received substantial damage when the pilot failed to maintain required airspeed during takeoff resulting in a…Incident 20180803024309IEmbraer EMB-145LR · Newark, NJOn August 3, 2018 at approximately 1137 local time, an embrarer 145 aircraft, operated by expressjet, at Newark international airport located at gate 26X, was being pushed back from the gate and struck a catering truck parked behind the aircraft. The force of…Accident 20180803014899ABrantly B-2 · Midland, MIOn August 3, 2018 at 4:05 pm eastern daylight time, a Brantly B2A helicopter, N5901X, registered to and operated by an airline transport pilot received substantial damage during an autorotation at the Midland barstow airport (ikw), Midland, Michigan. Visual…Incident 20180803013629ICessna 206H · St. Louis, MON9536F departed spirit of St. Louis airport (ksus) and was on a VFR photo flight in the vicinity of lambert airport (kstl) aprroximalty 5 NM east of the airport. During the flight no indications of an imminent issues was noticed by the pilot. During a turn…Accident 20180803009849ARaytheon 58 · Greenville, SCAircraft missed the approach to runway 19, circled and landed on runway 28. The aircraft slid off of the end of runway 28Incident 20180803009839ICessna 180K · Fairbanks, AKPilot was taxing off the beach when the plane turned hard right, the pilot applied full left rudder, but the plane continued right, pilot was unable to stop the engine quickly enough so the propeller chopped into the leading edge of the wing of the plane…Accident 20180803009829AAirbus Helicopters EC 130 T2 · Mullen, NEOn August 3, 2018 at approximately 1515 local time N130TG, an Airbus EC-130-T2 helicopter, departed controlled flight at approximately 200-300 feet AGL while circling a proposed landing area at an off airport location. The helicopter was witnessed on arrival,…Accident 20180803009809AMooney M20J · Lopez Island, WAAccident aircraft observed by commercial pilot who was in flight at the time of the accident. Witness reports accident aircraft announcing intentions to land at Lopez Island Airport, moving slowly just north of the airport. Subsequently witness observed the…Accident 20180803009599AColumbia Aircraft Mfg LC41-550FG · Dfw, TXAfter landing on a remote runway of Dfw airport, the small ga aircraft received a long and complex taxi route to the corporate ramp. The private pilot who had no prior experience operating into Dfw airport and was planning to connect to an airline flight,…Accident 20180803009589ACameron Balloons US A-250 · Hartsel, CODuring deflation of balloon envelope after landing, the basket was pulled onto its side by the partially deflated envelope. 2 of the 11 occupants fell out of the basket. 1 occupant landed on top of the other occupant. 1 occupant seriously injured. 1 fatality.