NTSB investigations: Piper PA-28-140, VT
16 cases on aircraft the registry lists as Piper PA-28-140. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1967 | 4 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 4 |
| 1973 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1987 | 1 |
| 2014 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.NTSB NYC87LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, VTWhile cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped…NTSB NYC77FNC30Accident · Serious injuriesClosedPiper PA-28 · Post Mills, VTNTSB NYC76DNC43Accident · No injuriesClosedPiper PA-28 · Post Mills, VTNTSB NYC76DNC44Accident · No injuriesClosedPiper PA-28 · Post Mills, VTNTSB NYC74AN044Accident · 3 fatalClosedPiper PA-28 · Manchester, VTNTSB NYC72FNC14Accident · Serious injuriesClosedPiper PA-28 · Manchester, VTNTSB NYC71FFA55Accident · No injuriesClosedPiper PA-28 · Underhill, VTNTSB NYC71DFA54Accident · No injuriesClosedPiper PA-28 · West Dover, VTNTSB NYC71DFA47Incident · No injuriesClosedPiper PA-28 · Burlington, VTNTSB NYC70D0101Accident · Minor injuriesClosedPiper PA-28 · Bondville, VTNTSB NYC69D0231Accident · No injuriesClosedPiper PA-28 · Montpelier, VTNTSB NYC68F0316Accident · No injuriesClosedPiper PA-28 · Burlington, VTNTSB NYC68A0037Accident · 1 fatalClosedPiper PA-28 · Waitsfield, VTNTSB NYC67D0632Accident · No injuriesClosedPiper PA-28 · Burlington, VTNTSB NYC67D0486Accident · No injuriesClosedPiper PA-28 · Basin Harbor, VT