NTSB investigations, VT
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventStateOrRegion\" = 'VT' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA' 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 NYC00LA012Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Whiting, VTThe pilot's inadequate preflight passenger briefing, which resulted in control interference.NTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.NTSB NYC99FA199Accident · 3 fatalField investigationFinal reportCessna P210N · Worcester, VTThe pilot's inadequate in-flight planning/decision, his failure to follow the published instrument departure procedure for the particular runway, and his continued flight into known adverse weather. A factor was thunderstorms.NTSB NYC99LA228Accident · No injuriesLimited investigationFinal reportPiper PA-601P · West Dover, VTwas the diverted attention of the pilot, which resulted in his failure to maintain airspeed, and his failure to lower the landing gear prior to landing.NTSB NYC99LA135Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Bennington, VTThe pilot's inadequate pre-flight briefing which resulted in control interference by the right front seat passenger.NTSB NYC99FA123Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · West Dover, VTWas the failure of the pilot to maintain control of the airplane during an aborted landing. Factors were the pilot's lack of familiarity with the airplane, the variable winds, and night conditions.NTSB IAD99LA024Accident · Serious injuriesLimited investigationFinal reportBell 47-G5 · Essex Junction, VTthe pilot's improper entry into the autorotation, which resulted in the loss of power and a low rotor rpm condition. Also causal was the pilot's improper execution of the autorotation which resulted in the hard landing. Factors in the accident were the…NTSB NYC99FA007Accident · 2 fatalField investigationFinal reportCessna 172G · Bennington, VTThe pilot's VFR flight into IMC. Contributing factors were the pilot's lack of recent experience, mountainous/hilly terrain, and clouds.NTSB IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.NTSB NYC98LA182Accident · Serious injuriesLimited investigationFinal reportPiper J3L-65 · Morristown, VTA loss of engine power for undetermined reasons.NTSB NYC98LA132Accident · Minor injuriesLimited investigationFinal reportExtra Flugzeugbau Flugzeugbau EA260 · Georgia, VTThe pilot's inadequate inflight decision and the loss of engine power due to a blocked vent line. A contributing factor was an unreliable fuel gauge.NTSB IAD98LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Rutland, VTthe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: unfavorable (headwind) conditions, and brush/small trees in the forced landing area.NTSB NYC98LA006Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Bennington, VTThe failure of the cyclic control due to an improper modification by the pilot/owner.NTSB NYC97FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Glastenbury, VTthe pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.NTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.NTSB NYC97LA119Accident · Minor injuriesLimited investigationFinal reportEnstrom F-280C · Sharon, VTThe pilot's improper decision to descend and fly at 100 feet over a river and his failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with wires.NTSB IAD96LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · Stowe, VTfailure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.NTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.NTSB NYC96FA023Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hartford, VTthe pilot's inadequate preflight planning/preparation, his inadequate removal of airframe ice, and his failure to maintain adequate airspeed, which resulted in a stall/spin and an inflight collision with terrain. Factors relating to the accident were: the…NTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.NTSB BFO96FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Norwich, VTloss of engine power for undetermined reason(s), during a low altitude operation. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB NYC95LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rutland, VTLoss of engine power during takeoff for undetermined reason(s), which resulted in a forced landing and subsequent collision with a tree and barn.NTSB NYC95LA228Accident · No injuriesLimited investigationFinal reportCessna 150M · Rutland, VTthe loss of engine power for an undetermined reason.NTSB NYC95LA186Accident · No injuriesLimited investigationFinal reportCessna 150E · West Addison, VTThe pilot's selection of an unsuitable landing area. A factor is a soft landing area.NTSB NYC95LA161Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Warren, VTa failed elevator cable which resulted in an inflight loss of control and uncontrolled contact with trees.NTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.NTSB NYC95FA129Accident · 2 fatalField investigationFinal reportCessna T210N · Monkton, VTfailure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.NTSB NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.NTSB NYC95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mount Snow, VTThe pilot's inadequate compensation for wind which resulted in the airplane drifting into a snow bank and nosing over.NTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.NTSB BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.NTSB BFO94LA114Accident · No injuriesLimited investigationFinal reportCessna 150 · Swanton, VTThe student pilot's failure to maintain directional control.NTSB BFO94LA087Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Morrisville, VTThe pilot's premature release from the tow plane. The lack of lift and the downdraft were factors.NTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.NTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…NTSB BFO94LA003Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morrisville, VTThe pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.NTSB BFO93LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stowe, VTThe pilot's improper in-flight planning/decision. A related factor in the accident was: the partial loss of engine power for an undetermined reason.NTSB NYC93LA155Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Lyndonville, VTAn inadvertent stall of the airplane as a result of the pilot's failure to maintain adequate airspeed and improper use of the carburetor heat and flaps during takeoff which degraded aircraft performance.NTSB BFO93LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob Speed Astir II · Chester, VTThe pilot's inadequate inflight planning and an in flight encounter with a downdraft while on final approach.NTSB NYC93LA121Accident · No injuriesLimited investigationFinal reportCessna 182Q · Randolph Center, VTThe pilot selected unsuitable terrain which resulted in collapse of the landing gear and the airplane nosing over. A contributing factor was a soft/wet runway.NTSB BFO93FA030Accident · 1 fatalField investigationFinal reportAmerican General AG5B · Vergennes, VTVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…NTSB NYC93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Dover, VTThe pilot's failure to maintain directional control during takeoff, and his inadequate remedial actions, resulting in a collision with a snowbank. Factors related to the accident were the ice covered runway and the snowbank along the runway edges.NTSB BFO92LA115Accident · Minor injuriesLimited investigationFinal reportGeorge A Chaffee Kitfox II · Shelburne, VTThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing was the pilot's diverted attention to an open door, and an inadequate preflight inspection.NTSB BFO92LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTThe pilot's failure to maintain clearance with the terrain. Contributing to the accident was a dark night and the lack of familiarity with the geographic area.NTSB BFO92LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Warren, VTThe pilot's failure to select a safe altitude for flight in mountainous terrain. The downdraft was a factor.NTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.NTSB NYC92LA019Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Manchester, VTThe pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.NTSB NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.NTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.