NTSB investigations: Cessna 150A, 1964
17 cases on aircraft the registry lists as Cessna 150A. 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
| 1964 | 17 |
|---|---|
| 1965 | 16 |
| 1966 | 21 |
| 1967 | 8 |
| 1968 | 9 |
| 1969 | 10 |
| 1970 | 7 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 4 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 3 |
| 1977 | 4 |
| 1978 | 3 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1964
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
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") = 1964
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
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 UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANTSB UNK65X0128Accident · No injuriesClosedCessna 150 · Alliance, OHNTSB UNK64X4136Accident · No injuriesClosedCessna 150 · Longmont, CONTSB UNK64X3512Accident · No injuriesClosedCessna 150 · Mountain Home, IDNTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSNTSB UNK64X2710Accident · No injuriesClosedCessna 150 · Rhinebeck, NYNTSB UNK64X2699Accident · No injuriesClosedCessna 150 · El Monte, CANTSB UNK64X2400Accident · No injuriesClosedCessna 150 · Denver, CONTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GANTSB UNK64X1602Accident · No injuriesClosedCessna 150 · St Meinrad, INNTSB UNK64X1566Accident · No injuriesClosedCessna 150A · Boca Raton, FLNTSB UNK64X1040Accident · No injuriesClosedCessna 150 · Wray, CONTSB UNK64X0588Accident · No injuriesClosedCessna 150 · Broomfield, CONTSB UNK64X0431Accident · No injuriesClosedCessna 150 · Ames, IANTSB UNK64X0207Accident · No injuriesClosedCessna 150A · Italy, TXNTSB UNK64X0175Accident · No injuriesClosedCessna 150A · Atlanta, GA