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.
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
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.
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.NTSB 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…NTSB 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.NTSB CEN21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Columbus, MSThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Williston, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB ERA21LA007Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 8KCAB · Ellijay, GAThe pilot's improper landing flare which resulted in a bounced landing and a subsequent noseover.NTSB 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.NTSB 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.NTSB 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.NTSB WPR21LA003Accident · 1 fatalClass 3 · LimitedFinal reportEvolution Revo · Hawthorne, CAThe pilot’s failure to maintain aircraft control during takeoff.NTSB 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.NTSB 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.…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN21LA004Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Lake Elmo, MNA total loss of engine power for reasons that could not be determined.NTSB 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.