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 20121110025209ICessna 140 · Cicero, INThe aircraft initially touched down at Mcgill airstrip (18II) approximately 25 yards from the end of the grass strip in a north to south direction with gusting winds from the south to southwest direction. The aircraft encountered a hump in the airstrip at…Accident 20121110024689ACessna 421C · Shaver Lake, CAScott clarke departed the salinas airport (ksns) on November 11, 2012 at approximately 1830 local. Mr. Clarke had 173 gallons of fuel added to the aircraft and purchased 4 quarts of oil before the flight. The airplane was fueled between 1400 and 1600 local…Accident 20121109028179ACessna 210L · La Grange, TXOn November 9th, 2012 at approximately 07:00AM aircraft N732BL Cessna 210 enroute from san marcus, Texas (khyi) to baytown, Texas (khpy) experienced a loss power and was forced to make an emergency landing and subsequently flipped over after landing in a…Incident 20121109024119IFairchild SA227-AC · Minneapolis, MNAircraft made normal landing on runway 12R at msp. All 3 green landing gear indicator lights were illuminated before touchdown according to pilot. After 50 to 100 feet on landing rollout, the left main gear collapsed and aircraft skidded off left side of…Incident 20121108027729IBeech M35 · Cedar Rapids, IAUpon landing on runway 13 at Eastern Iowa aiport, Cedar Rapids, IA. Landing gear collapsed after landing. The weather was VFR conditions with winds from the south 14 gusting to 19.Incident 20121108025969IDouglas DC-6B · Deadhorse, AKA totonduk outfitters' ltd (dba everts air cargo) DC-6-B, N151, landed several feet short of runway (rwy) 23 at the Deadhorse Airport (scc). The short landing resulted in the left inboard main tire striking and destroying one of the green runway end…Incident 20121108025269IPiper PA-32R-301 · W Palm Beach, FLOn or about 1413 local time, a PA-32-301R operated by [privacy data omitted], [privacy data omitted], holder of a private pilot certificate, was landing on rwy 28L when the right main gear collapsed and the aircraft veered to the north and exited the runway.…Incident 20121108024359ICessna 177RG · Mesa, AZ11/08/2012 Aircraft was on final to ffz. Pilot moved gear lever to gear down position. Gear moved to the down position as visually verified by the pilot. The nose landing gear down and locked light was not illuminated. Pilot cycled the gear up and down with…Incident 20121108023809IPiper PA-31 · Fort Lauderdale, FLI recieved notification at 16:40 LCL on 11/8/2012 of a disabled PA-31, C-6JBB at kfxe that had landed, and upon rollout had the nosewheel tire assembly fall off the aircraft during landing rollout. The pilot, [privacy data omitted] stated he was cleared to…Accident 20121108023529ANorth Wing Uum Scout X-C · Waterville, WAAircraft entered a stall spin at too low of an altitude and was unable to recover.Incident 20121107025959IReims F406/Caravan II · Bethel, AKAt approximately 1030 on 11/7/2012, the air carrier's director of operations informed the cmt that one of their aircraft was circling the Bethel Airport with a nose landing gear that failed to extend. According to information received from the Bethel tower…Accident 20121107025439ACessna P210N · Conway, AROn November 7, 2012, at 1128 CST, Cessna P210N, N887JA, registered to r. j. allen and associates, appeared to experience a lose of power shortly after takeoff from runway 26, dennis f. cantrell field (cws), Conway, AR. The aircraft was observed by several…Incident 20121107023409IDorman Donald Thoresen Bakeng Duce · Salt Lake City, UTPilot planed a short dvfr flight from slc to tvy. Shortly after departure from slc at approximately 10 west of slc and at about 5,500 MSL (1,300 AGL) he experienced what he perceived as sever engine vibrations. He shut down the engine and landed uneventfully…Accident 20121106028159ARobinson Helicopter R44 II · Bryan, TXStudent pilot was on second solo flight of the day. When the collective was applied the helicopter became light on the skids and started to hover the helicopter rolled right, the student corrected with a left cyclic movement which caused left skid to contact…Accident 20121106025379APiper PA-28-140 · Anadarko, OKDuring an attempted down wind landing to the south at Anadarko, OK, (F68) witness stated that the aircraft departed the left, (east) side of runway and the pilot aborted the landing and attempted a go around for a up wind landing. Per the local weather report…Accident 20121106024669ACessna 172M · Patterson, CAOn November 6, 2012 at approximately 1842 UTC, N21391, a Cessna 172, depart the modesto city airport (kmod) with two people on board. The aircraft was piloted by a private pilot with 520 hours or flight experience. Another person occupied the right seat of…Accident 20121106024479ACessna 208B · Wichita, KSN793FE departed kict and while in the climb reported to ATC of oil on his windshield and an engine failure. Wanted vector back to airport. With no altitude available, pilot made and emergency landing in a field. The aircraft rolled out through the field and…Incident 20121106024339IBombardier CL-600-2B19 · Charleston, WV11/06/2012CHARLESTON airport, WV (crw): psa airlines (vnaa) flight 2375, a CRJ2, diverted and landed on runway 23 due to a cracked windshield. The ARFF responded and the aircraft taxied to the ramp without incidentcrew stated while enroute at FL340 they…Incident 20121105025939IPiper PA-18-150 · Anchorage, AKThe PIC landed on an off-airport ridge on the north side of Mt. Susitna. The PIC taxied to turn around and taxi back for takeoff. In the turn one of the tires hit a divot, the wind picked up the tail and the aircraft ended up on its nose. The PIC exited the…Incident 20121105025469IBert Floyd S Pitts S1S · Lancaster, SCAircraft veered to the right after landing, pilot could not control the aircraft and departed the ruway to the right. Minor damage found on left landing gear and left lower wing tip.Accident 20121105025279APiper PA-28R-180 · Fort Lauderdlae, FLThe aircraft landed runway 31 at fxe and experienced a partial landing gear colapse. Single pilot on board. No injuries noted. The right main landing gear colapsed on roll-out according to the pilot [privacy data omitted]. [privacy data omitted] Stated that…Accident 20121105025099ADarrell G Sorensen Sprint MX II · Groesbech, TXOn 5 November 2012 the aircraft N460JS a quicksilver sprint mark ii serial number 0686 was executing a go around after an aborted landing to the north at the pilot/owner's home. The aircraft was observed starting a climb then appearing to stall banked to the…Incident 20121105024779IHawker-Siddeley Hunter MK 58A · Point Mugu, CAHawker hunter MK-58-A, N327AX, landed on runway 21 with the landing gear retracted at naval air station, Point Mugu, CA. The aircraft came to a stop on the runway, and the pilot exited the aircraft with no injuries.Incident 20121104027239IBeech 35 · San Angelo, TXOn November 4, 2012, at approximately 19:30 CDT, N4525V, a Beechcraft 35, was enroute from midland airpark (kmdd), located in midland, Texas to david wayne hooks memorial airport (kdwh), located in spring, Texas, the aircraft lost all electrical power. Pilot…Accident 20121104026779ACentral Ohio Dragonfly Clubllc DRAGONFLY-C · Darbyville, OHAt the wesmar aerodrome in Darbyville Ohio N667DF was taking off on a grass strip while towing a hang glider. At mid field the pilot turned north into the wind. Upon reaching an altitude of approximately 80 feet the engine seized. The pilot released the hang…Accident 20121104025949ABellanca 7ECA · Kenai, AKAfter take off from Kenai, Alaska (ena), leveled off at 900 feet to pattern, engine stopped (not seized). Actuated carb heat, rotated fuel tank selector on/off, no help. Kenai tower notified of engine failure. Pilot made a power off landing approximateley 1/2…Incident 20121104025519IChampion 7EC · Wappingers Fall, NYThe pilot was performing a wheel landing to a full stop on runway 24 with a slight crosswind. The pilot stated he might have set the tail down too quickly and the aircraft veered to the right. The pilot applied full left rudder but the aircraft exited the…Accident 20121104025079ACessna 310 · Stotts City, MOThis was the first flight after an overhaul of the right engine. The private pilot/aircraft owner occupied the left seat. As he was not multiengine rated he was accompanied by a multiengine rated commercial pilot/flight instructor who occupied the right seat.…Accident 20121104024939ACessna 150F · Gothenburg, NEOn November 4, 2012, Cessna 150F, N8375G, impacted terrain on final approach to the grass runway 32 at Quinn Field Airport (gte), Gothenburg, Nebraska at about 1030 CST. The student pilot, sustained fatal injuries. The aircraft was operated as an…Incident 20121104024909IBeech 58 · Bessemer, ALThe pilot stated that on the night of November 4,2012, he landed N3713N, and forgot to put the aircraft landing gear down. He stated that on the approach to runway 23 at Bessemer airport (eky), he made radio contact with the airport and started a descent on…Accident 20121104024889AWaco SRE · Lafayette, LAPilot stated after landing on roll out the aircraft veered to the right. He then tried to correct with left rudder and left brake, with a touch of power... No response. The pilot stated the next thing he knew the aircraft went on its nose and over.Accident 20121103027199ACessna 172S · Roanoke, TXOn November 3, 2012, about 10:40 central daylight time, a 2005 Cessna 172S aircraft, N985GE, impacted a mobile ground vehicle during the final landing phase of flight at the private northwest regional airport ( 57F) located near Roanoke, Texas. The student…Accident 20121103026462ACessna 172S · Van Nuys, CAOn November 3, 2012, at 1420 PDT, a ground impact occurred in the run-up area of runway 16 right at Van Nuys Airport, Van Nuys, CA. N4417S, a Beechcraft, taxied forward and struck the left horizontal stabilizer of N545ER, a Cessna 172S, severing the left…Accident 20121103026222ABeech D17S · Van Nuys, CAOn November 3, 2012, at 1420 PDT, a ground impact occurred in the run-up area of runway 16 right at Van Nuys Airport, Van Nuys, CA. N4417S, a Beechcraft, taxied forward and struck the left horizontal stabilizer of N545ER, a Cessna 172S, severing the left…Incident 20121103024869IDel Rio Arnold Lira Lancair Propjet · Grain Valley, MOThis aircraft departed charles b. wheeler downtown airport (mkc) at approximately 0815 local time. While climbing through 12,000 ft MSL, the cabin entry door came open and departed the aircraft. The pilot declared an emergency and requested to return to mkc,…Accident 20121103024469AHughes OH-6A · Atlanta, GAThe public use aircraft was manuvering between 500 and 400 feet AGL when it descended for unknown reasons. It hit a pole with it's skids and crashed in the middle of a street.Incident 20121103024109ICessna 402B · Milwaukee, WIOn Saturday November 3, 2012, Cessna 402B, N402CZ, flight no. FRG1540 departed mke at approximately 07:15 CDT with a destination of mrj. When the aircraft was approximately 25 miles west of mke the pilot reported that the left engine sputtered twice and then…Accident 20121103024049ALuscombe 8E · Horicon, WIOn November 3, 2012, at 1240 cdst a luscome 8E, N2368K, ground looped after an aborted takeoff from a private strip near horican, WI. The commerical rated pilot and his passenger received no injuries. The aircraft received substantial damage. The aircraft was…Incident 20121103023399ICessna TR182 · Colorado Spring, COOn 11/03/2012 at 1440 local time N738JA, a Cessna TR182, sustainined minor damage after the aircraft landed with gear up at kcos airport, 1 sole on board, no injuries. VFR condions prevailed at the time.Incident 20121102028949IPiper PA-28-235 · New Orleans, LAThe pilot was on a solo flight in the traffic pattern doing touch and go's. on his fourth approach during landing the aircraft porpoised and the nose gear collasped.Accident 20121102028539ACessna 172S · Mckinny, TXOn 2 November at or near 0853L a Cessna 172S serial number 172S10182 registered as N172FU while landing at mckinney Texas, Collin County Airport (tki) departed the runway went through a drainage ditch and came to rest on the east side of the airport in a dry…Accident 20121102027369ACessna 140 · Watsonville, CAThe pilot reported he was landing on runway 20 at Watsonville Municipal Airport (kwvi) on 11/02/2012 at approximately 1645 hours pacific time. He entered the traffic pattern and as he descended in altitude he applied 10 degrees of flaps and set the trim tab…Incident 20121102025429IBerkeley Michael Berkeley Lancair 4P · Woodruff, SCPilot stated he was on a routine flight and landing at his home airpark ,SC7. During landing the aircraft touched down on the runway as normal and then the propeller contacted the runway causing damage to the propeller. The pilot was not hurt. After the pilot…Accident 20121102025049AFairchild Heli-Porter Pilatus PC6/B1A-H2 · Georgetown, OHOn 11/02/2012 at 1801Z [privacy data omitted] was flying VFR into Brown County Airport and lost control of aircraft N476XP during landing. Aircraft came to rest in nearby trees. Accident location was the Brown County Airport in Georgetown Ohio. The pilot…Incident 20121102025029ICessna 172L · Winamac, INDuring landing rollout a deer ran into the left side of aircraft.Accident 20121102024489AE Paul Spackman Avid Flyer · Casper, WYOn 11/02/12 at approximately 1230 LCL N130PS, an amature built Avid Flyer, sustained substantial damage upon landing at Casper, WY. 1 sole on board no injuries. Day VFR conditions prevailed.Incident 20121102023789ICessna R182 · Denton, TXOn November 2, 2012, at approximately 15:00 central daylight time, a Cessna 182RG aircraft, N9031C, received damage to the propeller during the landing phase of flight at the Denton county airport located near Denton, Texas. Neither the instructing pilot, nor…Accident 20121101026769ACessna 320E · San Marcos, TXOn November 1, 2012, at 06:14 hours, a Cessna 320E, N10PM registered to first pryority bank of pryor Oklahoma crashed just after take off. IMC flight conditions prevailed and the pilot did not file a flight plan. The aircraft sustained catastrophic damaged…Incident 20121101025609IHooper Clint Challenger II Spec · Muskogee, OKOn November 1, 2012 around 18:30 CDT, aircraft N464FH, an operating amateur-built aircraft experienced engine failure. The aircraft made an emergency landing on U.S. Highway 69 using the north bound lane, approximately 4 miles north of the crossroad, state…Accident 20121101024929ARobinson Helicopter R22 · Alexander City, ALOn November 1, 2012, at 1645, central daylight time a Robinson helicopter, R22, registered to casablanca helicopter, LLC., departed alx on runway 36 heading for 16J, and crashed on the airport property. The commercial-rated pilot and copilot received minor…