NTSB investigations, VT
15 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 4 |
| 1998 | 1 |
| 2000 | 2 |
| 2005 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) 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 NYC06LA129Accident · No injuriesLimited investigationFinal reportChevrier, Armand J-3K · Charlotte, VTA complete loss of engine power on takeoff for undetermined reasons, which resulted in a forced landing.NTSB NYC05LA119Accident · No injuriesLimited investigationFinal reportPratt Ultravia Pelican-PL · Middlebury, VTA partial loss of engine power for undetermined reasons.NTSB NYC00LA219Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Post Mills, VTwas the pilot's improper fuel management which resulted in power loss due to fuel starvation.NTSB NYC00LA069Accident · No injuriesLimited investigationFinal reportMooney M20M · Montpelier, VTA blocked crankcase breather line due to ice and improper maintenance which resulted in further restricting the line. A factor in this accident was the below freezing outside air temperature.NTSB NYC98LA182Accident · Serious injuriesLimited investigationFinal reportPiper J3L-65 · Morristown, VTA loss of engine power for undetermined reasons.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 NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.NTSB BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.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 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 NYC88LA198Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Montpelier, VTEngine power loss due to fuel contamination of water and rust particles in fuel system.NTSB NYC85LA143Accident · No injuriesLimited investigationFinal reportEnstrom 280C · S.Woodstock, VTThe helicopter experienced a loss of RPM on liftoff and received substantial damage when it collided with a chain link fence. The plt stated that on liftoff to aprx 50 ft AGL, the RPM dropped off to 2800 and a loss of climb resulted. The plt descended in an…NTSB NYC83LA147Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Shelburne, VTThe acft crashed into a ditch during an emergency landing after a power loss. The dual instructional flight was climbingat about 200 feet when the power dropped 700-800 RPM. The pilot applied carb heat switched fuel tanks and turned to avoid a housing area.…