NTSB investigations, 1983, VT
2 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2006 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1983
AND 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\" = 230)
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 year(c."eventDate") = 1983 AND 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" = 230) 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 NYC84LA055Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Dummerston, VTThe plt initiated a practice autorotation from about 600 ft AGL. Airspeed was about 55 KTS with low m/r RPM due to low gross weight. A moderate flare was initiated in an effort to increase rotor RPM, reducing the airspeed to 40 KTS. However, the application…NTSB NYC84FA042Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Bennington, VTThe acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is…