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 20120828018499APiper PA-28R-200 · Monroe, WAOn 8/28/2012, Piper PA-28R-200 aircraft, N4922T, sustained substantial structural damage resulting from a hard landing at Firstair Field (W16), Monroe, WA. Flight instructor and commercial pilot student departed everett/snohomish county (pae), everett, WA for…Accident 20120828018159AAviat A-1 · Rolla, NDAircraft departed huron SD to Rolla ND about 4:00 pm CDT. About 10 miles south of Rolla the aircraft engine sputtered and quit the pilot made an emergency landing is a stubbel wheat field. During roll out and needing to avoid pot holes and a swampy areas in…Accident 20120828018129ACessna 180 · Brookville, OHPilot reported to law enforcement he was heading down the runway in attempt to takeoff when a crosswind gust caught the tail and made the airplane veer right then ground looped - result left gear collapsed, left wing, prop and left elevator impacted the…Incident 20120827020809IPiper PA-34-200 · Byron, CACFI was demostrating shortfield landing. After landing and rolling a few feet, nose gear collapsed.Incident 20120827020759IAmerican Eurocopter AS350B2 · Hollywood, CADuring aerial operations covering a news event, smoke was observed coming from the exhaust area of the engine of N725TV while it was in a hover. The pilot initiated an emergency landing, setting the aircraft down under power in a parking lot located at the…Accident 20120827020689AArrow Falcon Exporters OH-58C · Escalon, CAPilot concluding first aerial spray operation of the day. Witness states aircraft in steep rt. Hand bank, EST. 50FT above orchard when rotorcraft disappeared from sight. Local orchard workers first on scene. Aircraft laying on rt side with pilot still on…Accident 20120827020279ACessna P210N · Alturas, CAThe pilot stated that he was going to land at Alturas California for fuel. He stated that he descended over Alturas airport, turned right base for runway 3 with the gear down. He stated that he elected to go around. He stated that the aircraft 'was climbing'…Accident 20120827019649APowrachute Pegasus · Luling, TXPilot was flying low over friends field. Pilot did not see powerline crossing in front of powered glider flight path. Pilot managed to fly powered glider under powerline however parachute became entangled with powerline forcing powered glider to contact…Accident 20120827019329AWaco UPF-7 · Jim Falls, WIAircraft was topped off with fuel the night prior to flight. Preflight noted blue dye from fuel overflow on right wing below fuel vent. Aircraft engine quit after 1.5 hours of criuse flight. Pilot was able to restart engine with carb heat on and it ran for…Accident 20120827019299ATop Dog TD2 · Bemidji, MNDuring landing aircraft contacted runway in a steep nose down right bank.Accident 20120826028869AMooney M20C · East Hampton, NYA/c departed from runway 10 at hto, East Hampton, and sustained a power loss during initial climb. The pilot initiated a steep banked left turn, struck several trees north east of the runway and impacted the ground approximately 1NM north east of the…Accident 20120826023839AEvektor-Aerotechnik Sportstar · Columbus, OHPilot was taxiing the aircraft on taxiway bravo at the cmh airport, when the right hand brake failed, causing him to lose directional control. The aircraft left the taxiway and ran into the left grassy area south of taxiway bravo. The aircraft due to the r/h…Accident 20120826022319ABeech B24R · Dayton, VAOn August 26, 2012, about 1118 eastern daylight time, a hawker-beechcraft corporation B24R sierra, N9200S, was substantially damaged when it collided with trees and terrain during a forced landing after a reported loss of engine power near, Dayton, Virginia.…Incident 20120826021919ICessna TO-1D · Winstn Salem, NCPilot stated that he "pulled the power off too soon and flared too high" this resulted in the ground loop.Incident 20120826021809IBeech 35 · Boulder City, NVAircraft landed long and fast at rny 27 bvu. Went into soft dirt at end of runway and partially folded the right main landing gear. No injuries and minor damage to right main landing gear strut.Incident 20120826019249IPsota Frank J Hiperbipe SNS-7 · Ann Arbor, MIOn 8/26/2012 the pilot of aircraft N327HB reported an emergency in bound to Ann Arbor Municipal Airport, (arb). Aircraft landed on runway 24 without incident. Paramedics attend to and transported the pilot to the local hospital for observation.Accident 20120826019169AEberle John S Folker DR-1 Triplane · Parker, COOn August 26, 2012 at approximately 0946 MDT, N152RB, an experimental amateur built fokker DR-1 triplane was destroyed after impacting terrain near 7963 warbonnet trail Parker, Colorado. The sole occupant on board sustained serious injuries. Weather at the…Incident 20120826018809IGill Craig Lancair IV-P Propjet · Block Island, RIThe aircraft touched down at kbid on runway 10, 150 feet past taxiway bravo. Tire skid marks (both tires) immediately appear and angle 30 degrees to the left. The aircraft departed the runway at the intersection of charlie taxiway. The left under-wing pitot…Accident 20120826018189ATrick Trikes Stss · Wanamingo, MNPilot was making a low pass over runway to accomodate a video request. To accomodate a passenger request due to trees on the right of runway, a slight left turn was initiated resulting in a loss of altitude and airspeed. Pilot returned to straight and level…Accident 20120826017669ACessna 150G · Madera, CAThe pilot of N6346S CE-150-G departed (ifp) bull head city AZ on the morning of August 26, 2012. He planned to stop at Madera CA for fuel. Approximately 1 mile short of Madera the pilot reported that the engine quit due to fuel starvation and landed in a dry…Incident 20120826017209IWaco ATO · Dunkirk, NYOn August 26,2012 this aircraft departed dkk airport for a local VFR flight. After about 40 minutes of flight as the aircraft was returning to dkk airport the engine lost power at about 1000 feet AGL and 5 miles from the airport. The pilot performed an…Incident 20120825021109IAeronca 11AC · Nashville, TNUpon landing, aircraft ground-looped and contacted PAPI lights causing minor damage to right horizontal stablilizer.Accident 20120825021019AAmerican AA-1 · Llano, TXOn August 25, 2012, an AA-1, yankee, crashed, southeast of the Llano Airport, after experiencing an engine quit. The aircraft stalled and crashed, right wing first. A witness,flying in the area, reported seeing the entire top surface of the aircraft in a 70…Accident 20120825020459APiper PA-32-301T · South Lake Taho, CAThe aircraft initiated takeoff from runway 36 and struck trees approximately .4 miles off the end of the runway. With part of the left wing missing, the aircraft continued in an uncontrolled decent, impacted the ground, flipped inverted, and was destroyed by…Incident 20120825020259ICessna 208B · Kenai, AKWhile taxiing on taxiway echo at paen, the left brake failed causing the aircraft to veer to the right. The aircraft contacted a runway guard light with the right landing gear, damaging the light and requiring replacement of the brake unit.Incident 20120825019959IPiper PA-24-250 · Lake City, FL08/25/2012:Pilot departed Cannon Creek Airport (15FL) and flew to liveoak airport (24J).after fueling the aircraft departed live oak to return to Cannon Creek, while enroute the pilot prematurely extended his landing gear & realizing it was too early he…Accident 20120825019509ACirrus Design SR20 · Watkins, COOn 08/25/2012 at approximately 1058 hrs. MDT, N215VS, a Cirrus Design Corp. Model SR20 aircraft sustained substantial damage while landing at Front Range Airport (kftg), CO. There were no injuries to the sole occupant on board. Weather at the time was VMC.Incident 20120825019279IBoeing 737-924 · Houston, TXOn departure aircraft failed to pressurize. Rtb to iah. Iah mx determined a precooler control valve failed in the pneumatic system causing depressurization. Removed and replaced the precooler control valve and aircraft was returned to service.Accident 20120825019259ACessna 140 · Spearfish, SDOn Saturday August 25th at about 11:00 MDT a Cessna 140 was involved in an accident near kspf airport. After a cross country solo, the pilot went through the landing checklist. The pilot turned downwind at kspf and applied carb heat resulting in the engine…Accident 20120825018929AAeronca 11AC · Pacoima, CAAircraft on approach to kwhp, 1600 ft altitude at 1 mile from runway. One half mile from runway, at 200 ft, witnesses state aircraft banks right, loses altitude quickly and crashes into business parking lot.Accident 20120825018619APiper PA-24-250 · Steamboat Sprin, COOn 08/25/2012 at approximately 1251 hrs. MDT, N7774P, a Piper model PA-24-250 comanche aircraft was discovered destroyed after impacting terrain 9.5 miles west of Steamboat springs, CO. The sole occupant on board sustained fatal injuries. Weather at the time…Accident 20120825018589ASchleicher ASW-19 · North Dansville, NYOn 8/25/2012 at approximately 1530 local time N438AS (ASW-19B) crashed approximately 0.5 miles north of the Dansville, NY airport (kdsv). Initially there was confusion between the FAA and the local authorities whether or not this was a hang glider accident or…Accident 20120825018529ACessna U206D · Aniak, AKAircraft departed palmer Alaska (paq) enroute to Aniak Alaska (ani), while in level cruise flight, engine began to lose oil pressure, pilot attempted to divert to farewell Alaska. Engine started to come apart, cockpit filled with smoke, aircraft engine…Accident 20120825018489ADehavilland Beaver U-6 · Soldotna, AKThe flight was a part 135 fishing charter from longmere lake, Soldotna, AK to big river lake, cook inlet. Personnel on board were the pilot, a fishing guide, and 4 passengers. The flight departed longmere lake without incident and flew over kenai, AK prior to…Incident 20120824021529IAyres S2R-G10 · Blakely, GAOn August 24, 2012, [privacy data omitted], commerciat pilot certificate # [privacy data omitted], was conducting a spraying operation 2 miles west of Georgia hwy 62 west of Blakely, GA, when his a/c clipped some wire with the aircraft landing gear. Engine…Incident 20120824019799ICessna 182G · Miami, FLAircraft departed (kmac) macon, ga at 10:00 am local time on Friday the 24th, 2012 to Kendall Tamiami airport(tmb) Miami, FL with a fuel stop in (klee) leesburg, FL. 60 miles nw of Miami, FL. The pilot noticed the amperage meter discharging. The Miami tower…Accident 20120824019539ACessna 150M · Hardeman, MOPilot rented the aircraft from the owner who told the pilot the aircraft only had half fuel quantity, which is approximately two hours of fuel. The pilot flew approximately two hours prior to exhausting his fuel supply. Pilot attempted a forced landing in a…Accident 20120824018949ABell 407 · Abingdon, VAThe corporate turbine powered Bell model 407 helicopter had just transported 6 passengers from the bristol, TN motor speedway to the home of the ceo of the corporate operator. The landing area (1774MSL) is located adjacent to the shoreline of south holston…Accident 20120824018869AAeronca 11AC · Comfort, TXDuring a turn shortly after takeoff the aircraft descended rapidly and landed in a fenced corral area adjacent to the airfield. The aircraft was heavily damaged and the pilot received minor injuries.Incident 20120824018829IMooney M20K · Falmouth, MAThe flight originated at khgr (frederick, MD) at 0800 and ended at 5B6 (Falmouth airpark, MA) on 7-21-2012. Flight time was approximately 3 hours. The aircraft fuel was 72 gallons on take off and approximately 36 gallons upon landing. The pilot did not report…Accident 20120824018209ADestiny XLT · Hart, MIAfter watching a video recording of the accident supplied by witnesses on the ground. The pilot of the powered parachute stalled the eliptical style chute after turning downwind with a strong left quarting tailwind. The parachute collapsed inward starting at…Accident 20120824017889ACessna 152 · Ormond Beach, FLThe aircraft accelerated for take-off on runway 08 at (omn). The aircraft left the runway 2 times, but settled back to the runway surface, after the third rotation the pilot stated he did not think the aircraft was climbing therefore he elected to make an…Accident 20120824017219AStearman M-2 · Robbinsville, NJUpon landing on runway 11 at N87 after the wheels touched down the airplane began to swerve. A ground loop ensued and the aircraft nosed over inverted.Accident 20120823021359APiper PA-30 · Scappoose, ORPilot departed pearson field for Scappoose Industrial Airpark to refuel. Arriving at scappose the pilot attempted to lower the gear normally, but was unsucessful. He tried to cycle the gear and was still unsucessfull. He flew around for better than 30 minutes…Accident 20120823019869AStinson 108-2 · Winter Haven, FLDuring takeoff on runway 5 at Winter Haven Airport, pilot lost directional control of aircraft resulting in the aircraft departing the left side of the runway. Pilot continued the takeoff roll in the grass beside the runway and upon lift-off the bottom of the…Accident 20120823018469ACessna 172P · Shade Tree, MSPilot started take off roll and shortly thereafter heard what he thought was the door open (only window had opened). Pilot reached behind and to the left to close door and pushed left rudder in the process. Aircraft departed turf runway to the left and nose…Incident 20120823018419IPiper PA-44-180 · Danbury, CTOn 08/23/2012 at 2025 EDT, N692CF a Piper PA-44-180 landed on runway 26 at Danbury, CT with out lowering the landing gear. The impact with the runway damaged the left and right propellers as well as the inboard trailing edge of the left and right flaps.Accident 20120823017739APiper PA-32R-301T · Tampa, FLOn August 23, 2012, at approximately 1258 UTC, a Piper PA-32R-301T, N362DM, serial no. 7103220, had a low voltage warning light illuminate and noticiable sheen of engine oil develop on the windshield followed by a low oil pressure indication. The pilot made…Incident 20120823017659IBeech H35 · Jerome, IDThe aircraft was enroute from new Mexico to the Jerome, ID airport (jer). Upon arriving at the Jerome airport a successful landing was accomplished on runway 26. During the roll out the pilot mistakenly positioned the landing gear handle to the up position…Accident 20120822021969ABeech 35-C33 · Burlington, NCThe pilot made a hard landing and the right tire burst on touchdown. The aircraft then exited the runway on the right side and continued into the grass approximately 100 feet. The left wing hit a small sign before the aircraft came to a stop causing some…