NTSB investigations: Cessna 172K, MA
16 cases on aircraft the registry lists as Cessna 172K. 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
| 1969 | 1 |
|---|---|
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 3 |
| 1977 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2022 | 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\" = 'MA' 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 ('2072430'))
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" = 'MA' 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 ('2072430'))
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 ERA22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Barnstable, MAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun in gusting wind conditions.NTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallNTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB NYC96LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Gardner, MAthe pilot 's misjudgment of speed and distance during landing.NTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…NTSB NYC80DNA05Accident · No injuriesClosedCessna 172K · Bedford, MANTSB NYC77FNE25Accident · Minor injuriesClosedCessna 172 · Oxford, MANTSB NYC77FNA16Accident · No injuriesClosedCessna 172 · Marlboro, MANTSB NYC76DNA53Accident · No injuriesClosedCessna 172K · Methuen, MANTSB NYC76FNE15Accident · No injuriesClosedCessna 172K · Orange, MANTSB NYC76FNE14Accident · No injuriesClosedCessna 172 · Worcester, MANTSB NYC75DNA32Accident · No injuriesClosedCessna 172K · Hyannis, MANTSB NYC74FNE28Accident · No injuriesClosedCessna 172K · Palmer, MANTSB NYC72FNA27Accident · No injuriesClosedCessna 172 · Plymouth, MANTSB NYC72AN034Accident · 2 fatalClosedCessna 172K · Plymouth, MANTSB NYC70D0235Accident · Minor injuriesClosedCessna 172K · Marlborough, MA