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 ERA21LA005Accident · No injuriesClass 3 · LimitedFinal reportFokker DR1 · Wake, VAA total loss of engine power due to fuel starvation as the result of the improper installation of the ram air fuel vent tube, which resulted in the tube separating from the airplane during taxi and subsequent negative pressure inside the fuel tank.NTSB ANC20LA100Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Tok, AKThe mechanic’s failure to properly repair the tailwheel, which resulted in a malfunction of the tailwheel and a loss of directional control.NTSB WPR20LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Oregon City, ORThe pilot’s improper landing flare which resulted in a bounced landing, loss of directional control and subsequent collision with a hangar.NTSB ERA20LA342Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCB · DeFuniak Springs, FLThe failure of the left landing gear airframe cross tube during landing, due to corrosion hidden under riveted fairing.NTSB CEN20LA427Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASK21 · Hinckley, ILThe pilot’s improper control input during a bounced landing that resulted in the glider impacting terrain.NTSB CEN20LA425Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Spring, TXThe student pilot’s failure to maintain airplane control during climb and subsequent impact with terrain.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ENG20LA046Incident · No injuriesClass 3 · LimitedFinal reportThrush S2R-H80 · Donalsonville, GAA total loss of engine power due to a loose torque meter attachment nut in the reduction gearbox that jammed the planetary gearset causing the power turbine shaft to separate from the power turbine disk, resulting in the power turbine overspeeding and…NTSB CEN20LA421Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Lago Vista, TXThe pilot’s mismanagement of the fuel system which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to maintain airspeed which resulted in the airplane exceeding its critical angle of attack…NTSB WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB WPR20LA322Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32-300 · Silver Springs, NVThe pilot’s failure to maintain directional control during a nighttime landing with a crosswind, which resulted in a runway excursion and impact with a sign.NTSB ERA20LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Smyrna Beach, FLThe pilot’s decision to depart from a non-suitable surface, which resulted in a loss of directional control during takeoff roll.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB ERA20LA337Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Chester, CTThe pilot's unstable approach, which resulted in a hard landing, and the separation of the left main landing gear.NTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.NTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB ERA20LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · La Grange, NCThe pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.NTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB WPR20LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Island Park, IDThe pilot’s failure to maintain directional control during a crosswind landing.NTSB WPR20CA316Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Pacific City, ORA loss of directional control during landing for reasons that could not be determined due to lack of available evidence.NTSB ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.NTSB ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA20LA329Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Lincolnton, GAThe pilot's loss of airplane control while maneuvering at a low altitude.NTSB ERA20LA328Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Hamilton, GAThe pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.NTSB ERA20LA325Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe F 1 · West Kingston, RIThe pilot’s failure to conduct a proper preflight inspection and ensure the fuel was uncontaminated, which resulted in a partial loss of engine power and forced landing.NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Moosic, PAThe inadequate torquing of anchored-thru and free-thru studs during installation of the No. 2 cylinder, resulting in their fatigue fracture and subsequent total loss of engine power. Contributing to the undershoot landing was the pilot’s failure to divert to…NTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.NTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB WPR20LA311Accident · Serious injuriesClass 3 · LimitedFinal reportNorth American B25N · Stockton, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the erroneous fuel gauge indications and inadequate preflight planning and inspectionNTSB WPR20CA313Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 402 · Somerton, AZThe pilot’s failure to use full power during takeoff and his delayed decision to abort the takeoff, which resulted in a runway overrun and subsequent impact with terrain.NTSB ERA20LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Laconia, NHThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB CEN20LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · San Antonio, TXThe pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.NTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.NTSB CEN20LA402Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA46 · Hilltop Lakes, TXThe loss of engine power for reasons that could not be determined and the pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to establish and maintain a…NTSB WPR20LA310Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Clovis, NMThe pilot’s failure to maintain lateral control during initial climb due to distraction, which resulted in an in-flight upset and impact with terrain.NTSB ERA20LA331Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fort Lauderdale, FLThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s decision to continue to the destination following the loss of engine power to the first engine.NTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…NTSB WPR20LA333Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N500 · Peoria, AZThe balloon's encounter with unexpected windshear, which resulted in a hard landing and serious passenger injuries.NTSB ERA20LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Hollywood, FLThe pilot's failure to maintain directional control during a crosswind takeoff, which resulted in a collision with airport lights and a sign.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.NTSB ERA20LA320Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Newport, PAA total loss of engine power during cruise flight due to a disconnected carburetor mixture control cable which allowed the carburetor mixture lever to migrate to the cut-off position during flight.NTSB CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.