NTSB investigations

19,222 cases where NTSB found Aircraft.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" 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.

NTSB ERA21LA025Accident · Minor injuriesClass 4 · LimitedFinal reportAero Bristell Bristell LSA · Carlisle, PAThe pilot’s failure to maintain adequate clearance from trees during an attempted go-around in gusty crosswinds.Oct 18, 2020 · N438BL · Substantial damageNTSB ERA21LA024Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Winder, GAMaintenance personnel’s failure to properly secure the engine cooling fan attachment bolts, leading to vibration of the cooling fan, the overextension of the tension belt actuator, the failure of the drive system vee-belts, and the loss of power to the rotor…Oct 18, 2020 · N566BC · Substantial damageNTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.Oct 18, 2020 · N31136 · Substantial damageNTSB CEN21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Columbus, MSThe pilot’s failure to maintain directional control during a touch-and-go landing.Oct 17, 2020 · N26481 · Substantial damageNTSB WPR21LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson R44 · Pahrump, NVThe pilot’s failure to maintain helicopter control while hovering low over a body a water while facing into the sun, which resulted in a loss of visual reference and subsequent impact with the lake surface.Oct 16, 2020 · N500DL · Substantial damageNTSB ERA21LA023Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Zephyrhills, FLImproper torquing of the “B” nut at the fuel control unit, which led to a total loss of engine power and subsequent autorotation that resulted in substantial damage.Oct 16, 2020 · N777CP · Substantial damageNTSB CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.Oct 16, 2020 · N15608 · Substantial damageNTSB WPR21LA015Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · South Hill, WAThe pilot’s failure to ensure that the fuel supply had been completely drained of water, which resulted in a partial loss of engine power during takeoff due to water contamination.Oct 15, 2020 · N6585L · Substantial damageNTSB ERA21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportMuse Stol CH 750 · Sewanee, TNThe airplane’s encounter with a downdraft during the initial climb, which resulted in an impact with trees.Oct 14, 2020 · N750JD · Substantial damageNTSB ERA21LA022Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moneta, VAThe fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.Oct 14, 2020 · N7532E · Substantial damageNTSB ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.Oct 14, 2020 · N499CZ · Substantial damageNTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.Oct 14, 2020 · N631PF · Substantial damageNTSB ERA21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Williston, FLThe pilot’s improper landing flare, which resulted in a hard landing.Oct 13, 2020 · N6158G · Substantial damageNTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…Oct 13, 2020 · N47KC · DestroyedNTSB ERA21LA018Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH801 · Apison, TNA total loss of engine power due to fuel starvation, as a result of an incorrectly placarded fuel selector.Oct 12, 2020 · N801TP · Substantial damageNTSB WPR21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Bishop, CAA loss of engine power due to the pilot’s inadvertent closure of the mixture control which starved the engine of fuel and resulted in a hard landing and collision with terrain.Oct 11, 2020 · N22963 · Substantial damageNTSB ERA21LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Atlanta, GAA partial loss of engine power during takeoff due to a right magneto anomaly, which resulted in the pilot’s decision to abort the takeoff and the subsequent runway excursion.Oct 11, 2020 · N3595W · Substantial damageNTSB ERA21LA017Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Navion · Palmetto, FLThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions, which led to a runway excursion.Oct 11, 2020 · N8698H · DestroyedNTSB ERA21LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Friendly, MDThe pilot’s failure to maintain control of the airplane during an aborted landing and the flight instructor’s inadequate remedial action.Oct 10, 2020 · N155TE · Substantial damageNTSB CEN21LA014Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA32R · Kimberling City, MOThe pilot’s inadequate preflight inspection, which resulted in his inadvertent departure with the tow bar connected to the nose wheel, and the low approach while returning to the airport, which allowed the tow bar to contact trees.Oct 10, 2020 · N3445Q · DestroyedNTSB ANC21LA001Accident · No injuriesClass 4 · LimitedFinal reportDouglas C54 · Yakataga, AKThe pilots’ decision to land on a wet, soft runway, which resulted in the loss of braking action upon landing and a subsequent runway overrun and nose landing gear collapse.Oct 10, 2020 · N96358 · Substantial damageNTSB WPR21LA013Accident · No injuriesClass 4 · LimitedFinal reportRalph C Kimball Sea Rey · Parker Dam, CAThe inadvertent encounter with water wake during the takeoff sequence that degraded the airplane’s airspeed and resulted in the pilot’s failure to maintain clearance from obstacles during the initial climb.Oct 9, 2020 · N32RK · Substantial damageNTSB ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.Oct 8, 2020 · N227PF · Substantial damageNTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.Oct 8, 2020 · N8788D · Substantial damageNTSB ERA21LA011Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · West Palm Beach, FLThe pilot’s inadequate preflight inspection during which he failed to detect a flight control abnormality, and his failure to expediently abort the takeoff, which resulted in the co-pilot performing a delayed aborted takeoff and the subsequent runway overrun.Oct 8, 2020 · N8132Q · Substantial damageNTSB ERA21LA031Accident · No injuriesClass 4 · LimitedFinal reportSparrowhawk II · North Myrtle Beach, SCA ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.Oct 7, 2020 · N40380 · Substantial damageNTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.Oct 7, 2020 · N251SC · Substantial damageNTSB CEN21LA033Accident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe improper installation of a clevis pin in the rudder system which led to a loss of directional control during landing.Oct 7, 2020 · N790L · Substantial damageNTSB CEN21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportKjostad Jorgen A Wagabond · New Richmond, WIThe pilot's failure to maintain directional control on landing, which resulted in a runway excursion and subsequent nose-over. Contributing was the pilot’s lack of experience in the accident airplane.Oct 7, 2020 · N744K · Substantial damageNTSB WPR21LA033Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Minden, NVThe student pilot’s improper application of the airbrakes during final approach, which resulted in a landing area undershoot and subsequent hard, bounced landing.Oct 6, 2020 · N684KS · Substantial damageNTSB WPR21LA011Accident · 1 fatalClass 3 · LimitedFinal reportRans S-7 · Spirit Lake, IDThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 6, 2020 · N55893 · Substantial damageNTSB CEN21LA008Accident · 2 fatalClass 3 · LimitedFinal reportStephens William E Quicksilver MXL-2 Sport · Mount Vernon, INThe pilot’s exceedance of the airplane’s critical angle of attack during an aerobatic maneuver, which resulted in an aerodynamic stall and spin and loss of control. Contributing to the accident was the pilot’s decision to perform aerobatic maneuvers in an…Oct 6, 2020 · N2942A · Substantial damageNTSB WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.Oct 5, 2020 · N22979 · Substantial damageNTSB ERA21LA007Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 8KCAB · Ellijay, GAThe pilot's improper landing flare which resulted in a bounced landing and a subsequent noseover.Oct 5, 2020 · N787AC · Substantial damageNTSB CEN21LA050Accident · No injuriesClass 4 · LimitedFinal reportBellanca 1730 · San Saba, TXThe student pilot’s improper decision-making, which resulted in a total loss of engine power due to fuel starvation.Oct 5, 2020 · N7333V · Substantial damageNTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.Oct 5, 2020 · N3370E · Substantial damageNTSB WPR21LA006Accident · No injuriesClass 4 · LimitedFinal reportCapella XLS · Firth, IDThe pilot's failure to maintain adequate airspeed during the landing flare which resulted in an aerodynamic stall and collision with the ground.Oct 4, 2020 · N7143A · Substantial damageNTSB WPR21LA003Accident · 1 fatalClass 3 · LimitedFinal reportEvolution Revo · Hawthorne, CAThe pilot’s failure to maintain aircraft control during takeoff.Oct 4, 2020 · N449WB · Substantial damageNTSB ERA21LA006Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Fulton, NYThe mechanic’s improper maintenance, which resulted in the crankshaft expansion plug dislodging in flight and a subsequent forced landing.Oct 4, 2020 · N6179U · Substantial damageNTSB ERA21LA004Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Beechhurst, NYThe pilot’s selection of a landing area that provided inadequate distance from obstacles and his subsequent decision to abort the landing with inadequate takeoff distance available, which resulted in a high-speed collision with a concrete bulkhead.…Oct 4, 2020 · N6506M · Substantial damageNTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.Oct 4, 2020 · N912RE · Substantial damageNTSB CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.Oct 4, 2020 · N5196S · Substantial damageNTSB ERA21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 23 · Spruce Pines, NCThe pilot's failure to familiarize himself with the wind conditions at the destination airport and his failure to attain the proper touchdown point during landing, which resulted in a long, tailwind landing and subsequent runway overrun.Oct 3, 2020 · N8783M · Substantial damageNTSB ERA21LA008Accident · No injuriesClass 3 · LimitedFinal reportExperimental Quad City Challenger II · Northfield, NHA total loss of engine power due to oil starvation of the No. 1 cylinder. Contributing to the accident was the pinched No. 1 cylinder oil injection line.Oct 3, 2020 · N129AY · Substantial damageNTSB WPR21LA008Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Princeton, ORThe pilot’s failure to enrichen the mixture, which resulted in a partial loss of engine power.Oct 2, 2020 · N8678X · Substantial damageNTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.Oct 2, 2020 · N656V · Substantial damageNTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.Oct 2, 2020 · N7798M · Substantial damageNTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.Oct 2, 2020 · N4540F · Substantial damageNTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.Oct 2, 2020 · N62ZM · Substantial damageNTSB WPR21LA002Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Burlington, WAThe total loss of engine power for reasons that could not be determined based on the available information.Oct 1, 2020 · N601SA · Substantial damage