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 20100723042829AWarth Denni Classic SPT · Tea, SDOn July 23, 2010, pilot [privacy data omitted] flew N216TB, an experimental Warth thorp S-18, on a maintenance test flight around the Tea, SD airport. According to eye witnesses the aircraft took off and about 400-500 AGL the engine lost power. The pilot…Incident 20100723041879IShannon Ron Murphy Rebe · Arlington, WAPilot stated he was landing with a cross wind and a gust caught the aircraft causing him to ground loop. Pilot stated that he has approx 200 hours tail wheel time in a J-3. He just built this aircraft and only has 5 hours in it. Still flying phase one offAccident 20100723041199ADehavilland Beaver DHC- · Ketchikan, AKAircraft holding VFR, awaiting special VFR clearance into the Ketchikan airport class e airspace, encountered deteriorating weather conditions and very gusty winds of 30+ knots and strong downdrafts. Aircraft was observed by a witness, on the southeast side…Incident 20100723041169ICessna 402B · Farmingdale, NY07/23/2010 2030HRS pilot of N303PJ struck a rubber traffic cone with right propeller during taxi out of parking spot on ramp at atlantic aviation FBO ramp area in Farmingdale NY. FBO ramp personnel attempted to signal pilot to stop and pilot continued taxing…Accident 20100723040969AAir Tractor AT-502B · Whittemore, IAHeading north on takeoff roll from a 2640 foot sod airstrip pilot determined at approximately mid point the aircraft would not become airborne. An emergency dump of the chemical load was executed and the aircraft pitched nose up, then stalled. Recovery…Accident 20100723040699ACessna 206 · Ludington, MICessna 206, N82531 departed gratiot co. airport, Michigan, (amn) at 08:50 EDT on 07/23/2010 with the pilot and four passengers for rochester, MN (krst) . The aircraft was severly damaged when it was ditched in lake Michigan and sank about 5 miles west of…Incident 20100723040269ICessna 172B · St. James, MNDuring landing rollout, aircraft pitched forward and to the left causing a prop strike and small scrape on left wing tip.Incident 20100723040089ICirrus Desi SR22 · Monterey, CAThe pilot of N969JB was on final approach to Monterey Peninsula Airport (mry) runway 28L and stated that after crossing the numbers and about 10 feet off the runway he experienced a strong crosswind, some lifting of the right wind and a sudden move upwards…Accident 20100723039819ACessna 152 · Ephrata, WAOn July 23, 2010, [privacy data omitted] was acting as pilot in command of a Cessna 152 registration N6139M. During his first instructional flight of the day and as sole manipulator of the controls and while taxing for take-off, the aircraft struck a fire…Accident 20100723039149AClark Rober RV-9A · Oregon City, OROn July 23,2010, at approximately 1330 PDT, the aircraft appeared to have experienced a loss of power and collided with trees and a power line adjacent to hwy 213 about 7 miles south of Oregon City, Oregon. The [privacy data omitted] and sole occupant was…Incident 20100723038789IAirbus Indu A320-211 · Las Vegas, NVOn arrival at Las Vegas, the #3 main tire recap separated from the tire body. The right inboard flap leading edge was damaged, the honeycomb panel at the top of the right main landing gear wheel well was punctured, leaving a hole on the upper wing skin.Accident 20100722049609AEurocopter AS 350 B2 · Kingfisher, OKOn July 22, 2010, approximately 1925 central daylight time, a Eurocopter as 350 B2, N918EM, owned and operated by eaglemed LLC, was destroyed upon impact with terrain near Kingfisher, Oklahoma. A post-crash fire ensued. The commercial pilot and one flight…Accident 20100722043549AGrumman ACF G-164B · Alexandria, LADuring spray operations pilot experienced reduced engine performance and landed in a soft terrain rice feild. Airplane main gear sunk in mud and airplane flipped over on its nose.Incident 20100722043219IBeech V35B · Richmond, VADuring landing sequence, pilot stated that he put the landing gear handle in down position (tower confirmed). He stated that he hit a bump on the runway and inadvertantly selected the gear handle back to the up position.Incident 20100722042519IBombardier CL-600-2C10 · Omaha, NEOn July 22, 2010 at approximately 1950 CDT, a Bombardier CL-600-2C10, N387CA, operating as comair flight 269 inbound to Omaha, NE declared an emergency due to slat problems. The aircraft landed without incident.Accident 20100722041379ASmith Aerostar 60 · Cleburne, TXThe aircraft received a preflight inspection from the pilot and a designated airworthyness representative. The pilot completed an extend engine runup and systems check. The airplane was fueled by the pilot at a self service fuel pump. The aircraft departed…Accident 20100722041159ACessna 170B · Palmer, AKThe pilot stated that he spotted a back country airstrip and wanted to make some approaches without landing. On initiating a go around as he had planed, the aircraft was unable to climb and descended into the terrain.Accident 20100722041009ACessna 150M · Knoxville, TNPilot returning from first solo cross-country ballooned on landing and impacted on nose of aircraft.Incident 20100722040469ISikorsky SH-3H · Long Beach, CALos angeles county sheriff department Sikorsky, N950SB, model SH-3H was on a maintenance check flight in the Long Beach harbor area. During the maintenance check, the crew reported they heard a loud noise followed by the no. #2 engine shut down. Seconds…Incident 20100722040109ICessna 172S · White Plains, NY07/22/2010 During normal flight in cruise condition around khpn area, aircraft was struck by hawk on right hand leading edge. Aircraft was being used for flight training at time of incident. Aircraft returned to khpn and landed normally with no reported…Incident 20100722040069IStephens Do Searey · Long Beach, CAPilot landed the aircraft with the landing gear in the up position on runway 25R at Long Beach Airport resulting in minor hull damage and no injuries.Accident 20100722039372AAero Comman S2R · Mccook, NEOn July 22, 2010, [privacy data omitted], was taxiing for takeoff in Aero commander, N51AR. Pilot [privacy data omitted] failed to observe Piper, PA-18-150, N2287W parked on the ramp area and subsequently collided with the parked aircraft. Immediately after…Incident 20100722038939IPiper PA-18A150 · Dias Creek, NJThe pilot stated he completed a preflight, engine run up consisting of a magneto check and carburetor heat check. Both checks completed wih normal results. Departed the runway picked up the first banner of the day @ 11:30. At 11:40 and 1,500 feet the engine…Incident 20100722038009IPiper PA-28-161 · Little Rock, AROn July 22, 2010, at 1634 CDT, a Piper PA-28-161, N8189S, registered to [privacy data omitted], exited the side of the runway on landing at Little Rock National Airport, adams field, Little Rock, Arkansas, while on a student cross country. Visual…Incident 20100721044299IHill Richar Pietenpol A · Middleton, WIWhile performing a wheel landing the aircraft was hit by a gust of wind and inadvertently hit the propeller on the grass runway.Incident 20100721042739ICessna 310R · Pembroke Pines, FLOn July 21, 2010, approx: 1250 EST an incident at North Perry Airport (hwo) occured involving a Cessna 310R (N310BG). Pilot landed on runway 9L, during taxi pilot applied the brakes to stop the aircraft for left turn onto taxiway. The plane abruptly veered to…Accident 20100721041089AAllied Agca G-164-B · Prescott, WADuring aerail crop dusting operations pilot attempted take-off with full spray load. After rotation and departure the aircraft settled back to the runway. The aircraft departed the end of the runway and went through a barbed wire fence. The prop and lower…Incident 20100721039489IPiper PA-28-140 · St. James, MNDuring landing rollout, pilot raised the flaps and the nose gear collapsed underneath the aircraft.Accident 20100721039479AAir Tractor AT-401 · Bradford, ILDuring aerial application the aircraft lost power at approximetly 200-300 feet AGL. The pilot was able to maneuver the aircraft to an unidentified airstrip approximetly 5 miles to the west of his spraying location. During the landing the aircraft ran off the…Incident 20100721039399ICessna 177RG · Valentine, NEOn July 21, 2010 at approximately 10:45CDT, Cessna 177RG, N177SD, was enroute from rapid city, SD to waterloo, IA at 17,000 feet. The pilot reported to ATC that he had engine problems. The pilot diverted to Valentine, NE. The pilot stated to maintenance that…Accident 20100721038829ABeech V35 · Bend, ORThe pilot reported the aircraft ballooned 2 times landing rwy 34 at bdn. On the final landing attempt the nose wheel exploded, NLG collased, propeller struck the rwy surface and the aircraft left the right side of the rwy and spun 180 degrees. The right wing…Incident 20100721038419ICessna 402C · Vineyard Haven, MADuring take-off roll, on runway 16, the aircraft turned to the right sharply. The pilot stopped and inspected the aircraft and found that the right main landing gear wheel/tire assemble was leaning and resting on the lower strut, indicating a damaged axle.Accident 20100720055799AAeronca 11AC · Randolph, NYOn July 20, 2010 the student pilot, [privacy data omitted] conducted a preflight inspection of Aeronca chief, N-9120E. There were no mechanical irregularities noted during that inspection. The PIC and flight instructor for that flight, [privacy data omitted]…Incident 20100720043529IEmbraer EMB-145LROn July 20, 2010, at 1700C, expressjet airlines, inc. flight BTA2258 was 75 NM ene of new orleans, LA, enroute to houston, TX from asheville, NC at FL350, when an updraft lasting 1-3 seconds occurred (pilot reported as moderate turbulence). Seat belt sign was…Incident 20100720043519IPiper J3C-65 · Palmer, AKFlight instructor stated that after 2 touch and goes at the Palmer Airport that the engine quit on climb out at approximately 500 feet MSL. There was some confusion on which tank the fuel selector was positioned to and how much fuel was onboard the aircraft.…Accident 20100720043229ACessna 152 · Indian Head, MDWhile practicing take-offs and landings in the pattern at Maryland Airport (2W5) the weather changed and the winds increased from 2 knots to nw at 10 T0 15 knots. Student pilot attempted a landing on 36 and was unable to control the aircraft, landed long,…Accident 20100720043189APiper PA-28R-200 · New Bern, NCScenario: the aircraft had a reduction of engine power at about 400 feet AGL after take off from runway 22 with full length of 6004 feet available. Pilot turned immediately 180 degrees back to the airport. He then landed the aircraft on soft high grass on a…Incident 20100720042019ICiaglia E/H Christen EA · Oklahoma City, OKPilot departed rvs, tulsa, OK, after approximately 45 minutes of flight, pilot experienced a loss of engine power; the pilot landed the aircraft in a field; there were no injuries and no damage to the aircraft. The pilot who was also a certificated mechanic…Incident 20100720040999IBoeing 777-222 · Denver, COUA967 operating from iad to lax on 07/20/2010. Significant convective activitie on departure and along route of flight. Captain directed flight attendents to remain seated after takeoff and numerous times during flight . Also turned seat belt sign on numerous…Incident 20100720039929IDassault-Br Falcon 10 · Hudson, NYOn rotation for take-off from runway 3, at airport 1B1 the pilot saw a deer on right side of runway, which jumped up and impacted aircraft on right wing. He continued the climb and found that the aircraft controls seemed normal. Pilot called alb approach and…Incident 20100720039869IMooney M20B · Casper, WYPilot noted engine oil pressure dropping rapidly. Contacted Casper tower for clearance to land then was forced to land in rugged terrain about 3 miles short of airport post incident inspection revealed that right magneto had separated completely from engine…Accident 20100720039029APiper/Cub C PA-18-150 · ORThe pilot was Landing to the south. The aircraft touched down in the first 1/3 of the runway and bounced. The pilot initiated a go-around. In doing so the aircraft struck a fence at the end of the runway and subsequently barely cleared a small canyon…Incident 20100720037569IEmbraer-Emp ERJ 170-200 · Albany, NYNorthwest arilink flight #cpz 5685 (operated by compass air) diverted and landed on runway 1 (alb) due to smoke in the aft galley. The ARFF responded and reported a faulty coffee pot. The aircraft then taxied to the ramp without incident. Contract maintenance…Accident 20100719044589ACessna A188B · Clyde, OHDuring a spray operation pilot remembers a loss of power and adding full throttle but did not get any response. That is all that he remembers. The aircraft thenhit a grain auger, then flew, uncontrolled into a grain silo and came to rest next to a house 80…Accident 20100719043249ABell 206B-IIIWhile spraying susquehanna river for black fly. Pilot lost track of wires crossing river in the area being sprayed. While pulling out of spray run aircraft pulled up into 3 of 4 wires crossing river. Pilot stated he was aware of wires and just lost track of…Accident 20100719041779AAviat Aircr A-1B · Casper, WYAirman was conducting stop and go takeoffs and landings for tailwheel practice on runway 3 at the Natrona County International Airport. Completed two wheel landings with approximately 5 knot left crosswind. Attempted a three point landing and touched down at…Accident 20100719040879ABell 206L-3 · Wells, NVPilot accomplished a toe in approach and landing to a rock ledge approximately 550 above the terrain to allow a rescue person with equipment to board the helicopter. After liftoff from the rock ledge, the helicopter entered a steep nose down attitude and…Accident 20100719040499ARobinson He R44 II · Shreveport, LAStudent pilot had lifted off from grass field. As he lifted off, the aircraft started to weathervane into the wind and the student overcompensated with the rudder. The aircraft's vertical stabilizer and tail rotor struck the ground, causing structural damage…Incident 20100719040049IPiper Aerostar 60 · Lititz, PAWhile established on approach to rwy 26, N300LW instructed by lns ATCT to manuever to avoid overtaking other aircraft cleared for landing. Pilot retracted landing gear. ATCT then cleared N300LW for landing rwy 26, pilot subsequently failed to extend landing…Incident 20100719038799ICessna T207A · Grand Canyon, AZ[privacy data omitted] An airframe and powerplant mechanic for Grand Canyon airline at the Grand Canyon Airport was running up Cessna, CT207A,N7351U, for scheduled maintenance. The aircraft brakes were not set properly and aircraft moved to the left and hit…