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 CEN21LA082Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Spearfish, SDA total loss of engine power during initial climb for undetermined reasons.NTSB CEN21LA080Accident · 1 fatalClass 3 · LimitedFinal reportVans RV6 · Hitchcock, TXThe pilot’s impairment by the effects of ingested alcohol, which resulted in the loss of airplane control and impact with terrain.NTSB ERA21LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Milton, FLThe pilot’s failure to attain a proper touchdown point and his landing with a high approach speed, which resulted in a runway overrun.NTSB ERA21LA065Incident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Leesburg, VAThe pilot’s loss of directional control during landing in crosswind conditions. Contributing to the loss of control was the significantly underinflated nose landing gear tire.NTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…NTSB CEN21LA075Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32 · Windom, MNThe pilot’s spatial disorientation shortly after takeoff into night instrument meteorological conditions, which resulted in loss of airplane control and subsequent impact with terrain.NTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.NTSB WPR21LA080Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Palm Springs, CAThe student pilot’s failure to maintain aircraft control during an attempted go-around, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and subsequent impact with terrain.NTSB CEN21LA073Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Arden Hills, MNIncorrect connecting rod installation, which resulted in the failure of the nos. 5 and 6 connecting rods and subsequent total loss of engine power.NTSB ANC21LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Juneau, AKThe solo student pilot’s failure to maintain directional control during taxi in strong crosswind conditions, which resulted in a loss of control and subsequent impact with a ditch.NTSB ERA21LA059Accident · No injuriesClass 3 · LimitedFinal reportPiper PA38 · Pembroke Pines, FLA total loss of engine power due to fuel contamination.NTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.NTSB ERA21LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bellefonte, PAThe pilot's failure to maintain directional control while landing, which resulted in a runway excursion.NTSB ERA21LA058Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Georgetown, DEThe pilot’s failure to maintain airplane control while on landing in gusting crosswind conditions.NTSB CEN21LA069Accident · Minor injuriesClass 4 · LimitedFinal reportGlobe GC1A · Ottawa, KSThe student pilot’s failure to maintain attain proper pitch attitude of the airplane causing it to exceed its critical angle of attack, enter an aerodynamic stall, and subsequently impact terrain, and his poor decision making and lack of experience that led…NTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, NCThe pilot's loss of directional control during takeoff in crosswind conditions, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hollister, MOThe pilot’s failure to maintain proper airspeed control during an instrument approach in instrument meteorological conditions, which led to a bounced landing, collapsing the nose landing gear, and resulting in substantial damage.NTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…NTSB ERA21LA055Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot’s failure to maintain a proper glidepath while on approach to the runway, and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with a tree on final approach.NTSB ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.NTSB ERA21LA052Accident · 1 fatalClass 3 · LimitedFinal reportLancair Legacy FG · Hollywood, FLThe pilot/owner’s failure to properly reinstall the number 1 cylinder spark plug, which resulted in a partial loss of engine power during the initial climb. Contributing was the pilot's exceedance of the airplane’s critical angle of attack during an attempted…NTSB ERA21LA051Accident · Serious injuriesClass 4 · LimitedFinal reportJ&J Ultralights Sea-Wing · Placida, FLThe pilot/owner’s improper preflight inspection of the weight-shift trike, which resulted in a loss of control at takeoff due to an improperly adjusted wingtip.NTSB WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.NTSB CEN21LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lawrence, KSThe student pilot’s improper landing flare/touchdown which resulted in a hard landing.NTSB CEN21LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Canon City, COThe failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing. .NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB CEN21LA064Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · El Paso, TXThe pilot’s loss of control on takeoff during a touch and go landing, which resulted in a runway excursion.NTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.NTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.NTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.NTSB CEN21LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Johnson City, KSThe pilot’s improper decision to fly the airplane at too low an altitude resulting in the airplane impacting terrain.NTSB ERA21LA042Accident · Serious injuriesClass 3 · LimitedFinal reportRepublic RC3 · Advance, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.NTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB WPR21LA055Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · San Bernardino, CAA total loss of engine power due to fuel contamination. Contributing to the accident was an inadequate preflight inspection.NTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.NTSB WPR21LA053Accident · No injuriesClass 4 · LimitedFinal reportAir Creation Buggy · Benson, AZThe non-rated pilot’s unstable approach and failure to maintain aircraft control, which resulted in a hard landing and collision with terrain.NTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.NTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…NTSB CEN21LA053Accident · 1 fatalClass 3 · LimitedFinal reportTrick Trikes Stss · Holden, MOThe noncertificated pilot’s failure to maintain aircraft control during takeoff.NTSB WPR21FA044Accident · 1 fatalClass 3 · FieldFinal reportPiper PA38 · Grass Valley, CAA total loss of engine power due to the pilot’s improper fuel management, which resulted in fuel starvation.NTSB ERA21LA041Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20C · Laconia, NHThe pilot’s failure to maintain adequate clearance from trees during an approach in sun glare and hazy conditions.NTSB ERA21LA150Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Montgomery, NYThe pilot’s failure to maintain directional control during landing, resulting in a ground loop and structural damage to the airframe.NTSB ERA21LA040Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Raleigh, NCThe pilot's loss of helicopter control after entry into vortex ring state, which resulted in main rotor blade contact with the tailboom, and impact with the ground.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN21LA049Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Circleville, OHThe total loss of engine power due to an accessory drive gear that backed out impeding the other gears.