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 20100610035209APiper PA-46-310P · Ontario, CAThe pilot and flight instructor on board both stated that at approximately 17,000 ft MSL the aircraft experienced a loud "pop" or "bang". The pilot and flight instructor stated that this "pop" or "bang" led to a loss of engine power. The pilot and flight…Accident 20100610035199AAir Tractor AT-402B · Alcolu, SCApproximately 1725 local, [privacy data omitted] was spraying fungicide on a corn field near Alcolu, SC. While spraying, he made a turn, brought the aircraft back to wings level and saw a dead tree in front of him. The aircraft hit the tree, the pilot dumped…Accident 20100610005279ATexas Helic OH-13E/M74 · Los Banos, CADuring an aerial application, the engine quit operating causing the helicopter to crash. There were no injuries associated with this accident. This accident sustained substantial damage to the structure and main / tail blades. The engine appeared to have no…Incident 20100610005239IFlournoy Ma Flournoy MR · Gage, OKPilot flight from K00V to Woodward Oklahoma. At 7,500 feet noticed engine sputter. Aircraft had been airborne for two hours. Pilot elected to land on road approximately 12NM north of Gage Oklahoma claiming engine still running. During approach to highway,…Accident 20100609045039ACessna 210L · Tampa, FLOn departure from Tampa international airport N2263S had to accomplish an off airport landing due to an engine failure. Upon inspection of the engine the crankshaft was found shearedIncident 20100609041981IWaco UPF7 · East Alton, ILPilot of N9318 taxied his aircraft into N7019J, a lancaire that was tied down on the ramp at aln.Accident 20100609038069ACessna 172S · New Smyrna Beac, FLWhile flaring to land aircraft hit nose gear first. Wrinkling firewall and blowing nose wheel tire.Accident 20100609036399APiper PA-34-220T · Ankeny, IAPilot reported that on landing at Ankeny Regional Airport (ikv) he was unable to flare. The aircraft landed hard in a nose low configuration. The aircraft bounced twice, but the pilot was able to maintain lateral control. The pilot taxied to the airport…Incident 20100609035599ICessna 152 · Spanish Fort, ALAircraft N757PK departed kbfm about 10:40 CDT with a flight instructor and a student pilot on a training flight to evaluate cross-country navigation and diversions. They filed a flight plan to kmvc and obtained radar traffic advisories from mobile approach.…Incident 20100609035219IBeech A24R · Orange, TXWhile performing touch and go operations the landing gear selector was selected to the up position. Upon landing the landing gear selector was not get selected to the down position.Incident 20100609034609ISmith Aerostar 60 · Dothan, ALThis was a part 91 flight from sikeston MO to Dothan, AL. Approaching the airport on final the pilot selected 10 dergees of flaps and slowed. He then selected an addittional 10 degrees of flaps and moved the gear handle down. Final flaps were selected on…Accident 20100608039619APiper PA-28-180 · Lucedale, MSOn June 8, 2001, N5118L, departed fairhope, AL, for hattiesburg, MS (pib). Prior to departure the fueled with 50 gallons total. Twenty minutes into the flight, at 4500 altitude, the pilot notice a vibration in the engine. The engine started to run rough. He…Accident 20100608036789ABoeing B75N1 · Washington, DCOn June 8, 2010 at approximately 1010 eastern daylight time (EDT) (UTC-4), N27WE, a Boeing stearman model B75N1, registered to and operated by a private individual nosed over on landing on runway 01 at Ronald Reagan national airport (kdca). The personal…Incident 20100608036629ICessna 402C · Nantucket, MAOn 06/08/2010, Tuesday morning at 07:30, Nantucket shuttle inc. (Z4HC), N402NS, operated by [privacy data omitted] PIC, CE-402-C, landed Nantucket ma on runway 33 and received taxi instructions to the north ramp at ama Nantucket. The pilot requested a…Accident 20100608035159ACessna A188B · Orange, TXPilot attempted to take off on runway 22 headed south. Approximately 1000 feet into take-off roll aircraft drifted left and ran off runway and struck airport sign. The sign pole damaged left main landing gear. Pilot aborted take-off, aircraft came to a stop…Accident 20100608034879ABell 47G-4A · Shaw Island, WAOn June 9, 2010, during a telephone interview with the PIC, [privacy data omitted], he stated that the helicopter, Bell 47G (N7069J) which was equipped with two fixed floats, took-off from a private airstrip on Shaw Island along with passenger [privacy data…Incident 20100608034569IPiper PA-32-260 · Farmingdale, MEPilot told me he was out 7 miles from augusta, Maine where he had just taken off, he was at or about 2,700 feet when the engine quit with out any warning. He tried to regain power and could not. He landed the aircraft in a open hay field. Pilot mentioned the…Accident 20100608005999ACessna 305A · Berkley Townshi, NJAt touchdown on runway 6 at mjx, a gust of wind caused the aircraft to drift towards the left side of the runway. The pilot added right rudder and small amount of right brake. The passenger moved the throttle and added power. The aircraft over corrected and…Incident 20100608005979ICirrus Desi SR20 · Frederick, MD06/08/10PILOT [privacy data omitted] had a hard landing. Talked to [privacy data omitted] at landmark and was told there was damage to prop, nose gear and wrinkle in firewall. 06/14/10TALKED with [privacy data omitted] at landmark and was told the door had…Incident 20100608005959IBeech A36 · Mt. Vernon, OHThe pilot reported mansfield approach informed him that the transponder failed during an IFR flight plan from luk to 768. He elected to reset the transponder and troubleshoot the system when he noticed the "alternator out" light was illuminated. The pilot…Accident 20100608005559AHood John S Tango · New Port Richey, FLWhile in cruse flight N76HT experienced a partial power loss. Pilot stated he could not reach an airport, he decided to land on a secondary road. On short final a car turned in front of him and he had to adjust his flight path clipping a palm tree spining the…Incident 20100608005209IWeatherly A 620B · Hereford, TXOn June 8, 2010 at approximately 08:30 CDT, while making a spray run, the aircraft struck a sprinkler system. The pilot proceeded back to the airport to land. Upon touchdown at the airport, the right gear broke off and the aircraft slid off the side of the…Incident 20100607052669IEurocopter AS 350 B2 · New York City, NYDuring reposition from spot 2 to the heliport fuel deck at jra heliport, pilot did strike and break pier bulkhead light with tail of helicopter. Pilot hot fueled helicopter and did not inspect aircraft for damage. Pilot departed jra heliport enroute to jrb…Accident 20100607037389AStinson 108-1 · Galena, AKGround loop on takeoff from Galena Airport. No contributing factors.Accident 20100607036919ABeech 60 · Edenton, NCDuring the conduct of an instrument proficiency check, the instructor pulled the throttle on the left engine to simulate an engine failure on takeoff at approximately 20 feet in the air. Pilot claimed he tried to advance the throttles but instructors hands…Accident 20100607036229ASkystar Kitfox IV · Stanton, MNThe owner/pilot repaired the aircraft from a previous accident. The first flight after the repairs were made the owner departed from his private home airport to Stanton, MN. He did two landings at Stanton and on the third approach to landing the propeller…Accident 20100607035509AAir Tractor AT-602 · Knobel, AROn June 7, 2010, at approximately 1820 hours CST, an Air Tractor AT602 impacted the ground after performing an aerial application maneuver. Visual meteorological conditions prevailed at the time, there was no flight plan filed. The aircraft was totally…Incident 20100607035319IBeech N35 · Dallesport, WAAircraft departed rwy 30 at the Dalles airport for bfr and experienced total engine failure 10 minutes after takeoff while heading east. Pilot turned back and landed short of airport on highway 14 in Washington. No damage to airplane and no injuries to pilot…Incident 20100607034849IPiper PA-28RT-201 · Salt Lake City, UTOn 67/2010 at appox. 1102MDT a Piper PA28RT-201, N29557 takeoff slc rwy 35 aborted takeoff due to loss of power reported. Upon contact with rwy r/h main gear collapsed. A/c slid off rwy and contacted a taxi-light at intersection of taxiway K9 and came to rest.Accident 20100607034829ACessna 177RG · Marrietta, OHOn June 7, 2010 aircraft, N2106Q, Cessna 177 rg en-route from kump to kjgg cruising at 7000 ft had catastrophic engine failure. The pilot declared an emergency with indy center. The aircraft landed gear up in a soybean / tomato field just 1600 feet south of…Incident 20100607034649IAerostar IN RX 8 · Bend, ORPilot reported carrying passenger during balloon festival for pleasure flight without compensation, and winds began to increase to 6-8 mph. Landing initiated and basket tipped sideways on landing impact. Passenger did not hold on to basket as instructed and…Incident 20100607005589ILockheed SP-2H · San Bernardino, CAUpon landing rollout, aircraft brakes locked. Blew two tires.Incident 20100607005529IFriday Harbor, WASikorsky S-76 helicopter heading to vancouver from Victoria bc was flying along canadian airspace in cruise flight at 5500 ft, while doing cruise checks, PIC heard a noise as if washer or bolt fell from the cb panel to the center console. The fp looked down,…Incident 20100606048369IFisher Mich Celebrity · Marion, KSAs reported by the Marion county sherriff and confirmed by photos, the aircraft experienced engine problems (loss of power) and landed on hwy 77 just south of K-150 near Marion, Kansas. On approach, the aircraft struck a power line with the right wing,…Accident 20100606035149APiper PA-18-135 · North Myrtle, SCOn June 6, 2010, at about 11:50 eastern standard time, a Piper PA-18-135 aircraft N2150A registered to barnstormer flite signs inc., operating as 14 CFR part 91 banner towing flight operated by a commercial rated pilot crashed off the runway while attempting…Incident 20100606034539IEllis F R I Quick Slvr · Wagoner, OKEngine quit while aircraft was in airport pattern. Pilot attempted to return to runway. Aircraft landed in adjacent field 300 yards from runway.Accident 20100606005579ABeech G35 · Marble, COOn June 6,2010, at approximately 0705 hrs MST, an Beechcraft , model BE-35, piloted by a licensed private pilot, was destroyed when it impacted the terrain 2.0 miles east of Marble, Colorado. Visual meteorological conditions prevailed at the time of the…Incident 20100606005489IGrumman G-44A · Mukilteo, WA[privacy data omitted] And PIC of N86627, a Grumman G44A executed an emergency landing on the water approximately 4 miles from the Mukilteo boat launch at 1:30 pm on 6/6/10. Aircraft departed reno,NV with a total fuel load of 90 gals heading to Friday…Accident 20100606005249APiper PA-28R-180 · Kingfisher, OKPilot was making his second landing on grass strip. Aircraft landed hard on left wing tip then on right wing and the nose gear collapsed. The aircraft slid to a stop. Both wings were rinkled and the nose gear collapsedAccident 20100605052449ABeech B19 · Ronkonkoma, NYOn Saturday June 5, 2010 , at approximately 1500 , CFI [privacy data omitted] cert # [privacy data omitted] was instructing [privacy data omitted] (student) in his own BE-19 aircraft N1958W. The aircraft departed islip on runway 24 heading south. As the…Incident 20100605040199IWaco UPF-7 · Junction City, KSThe airman was taxiing to the departure end of runway 23 at Junction City, KS, a turf runway, when near the end of the runway, he struck a 55 gallon drum used to mark the runway end, causing damage to the propeller and fairing around the right main gear.…Incident 20100605038059IBeech 76 · Daytona Beach, FLPurpose of flight to build hours, dep dab enroute to key west, after take off engine started running rough with flucuating fuel pressure, return to dab, during taxi in non movement area of school the right wing tip stuck a illegaly parked golf cart. The wing…Accident 20100605037779ABeech F33A · Marana, AZN1565A was conducting a cross country flight from phx goodyear airport to Marana Northwest Regional Airport (avq). Various private pilot certification activities were conducted during the flight, including diversions to alternate airports. [privacy data…Accident 20100605036772AAirbus Indu A330-323 · Charlotte, NCAircraft was in line taxiway e, short of taxiway E10, for departure 18C . Clt tower asked if able to depart from taxiway E10, the crew replied that runway length was acceptable. Tower cleared aircraft to taxi into position and hold 18C at E10. During the turn…Accident 20100605036762AAirbus A321-231 · Charlotte, NCAircraft was stopped with parking brake set.Incident 20100605036441ICessna 175 · Hollister, CAWhile mechanic was working on the airplane, he moved the propeller while the magnetoes were in the on position and the aircraft engine started and the aircraft moved forward, striking an adjacent hangar. The force of the impact collapsed the hangar door onto…Accident 20100605036329ARobinson He R22 Beta · La Vern, CAHelicopter was returning to brackett field from the southeast at the end of a local flight. The tower cleared N7028U to land on taxiway sierra. The brackett tower controller reported that N7028U crashed on taxiway sierra between alpha and bravo. In his…Accident 20100605036219ACessna 172H · Farmington, UTDeparted btf Skypark Airport aircraft performing fine. Headed up Farmington canyon engine started losing performance at approx. 50 knots airspeed tried to turn around as terrain was raising faster than aircraft could perform, determined did not have enough…Accident 20100605035819ACessna 337 · Custer, SDJune 5, 2010, pilot[privacy data omitted] was out practicing touch and go landings in his Cessna 337 at Custer, SD. On his second takeoff, and about two-thirds down the runway, he experienced a rear engine failure. The pilot decided to continue with the…Accident 20100605035349ACessna 150M · Pahokee, FLOn June 05, 2010, about 1630 eastern standard time, a Cessna 150, (N2990V), registered to mikeric aviation departed from runway 35 at glades airport (phk) and crashed approx.1/2 mile north of runway, at latitude 26 47 15 n. and longitude 80 41 59 w of phk.…