NTSB investigations: Cessna 150A, 1965
16 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\") = 1965
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") = 1965
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 MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NENTSB MIA66D0284Accident · No injuriesClosedCessna 150 · Miami, FLNTSB NYC66F0317Accident · No injuriesClosedCessna 150 · Paramus, NJNTSB CHI66D0495Accident · No injuriesClosedCessna 150E · Louisville, OHNTSB LAX66D0119Accident · No injuriesClosedCessna 150 · Wasco, CANTSB OAK66D0086Accident · No injuriesClosedCessna 150 · Honolulu, HINTSB FTW66D0252Accident · No injuriesClosedCessna 150 · Clarendon, TXNTSB ANC66D0054Accident · No injuriesClosedCessna 150 · Glenallen, AKNTSB FTW66D0287Accident · No injuriesClosedCessna 150 · Edinburg, TXNTSB MIA66F0080Accident · Minor injuriesClosedCessna 150 · Tiptonville, TNNTSB ANC66D0004Accident · No injuriesClosedCessna 150 · Northway, AKNTSB ANC65D0016Accident · No injuriesClosedCessna 150 · Nenana, AKNTSB CHI65D0158Accident · Minor injuriesClosedCessna 182 · Fostoria, OHNTSB MKC65D0072Accident · No injuriesClosedCessna 150A · Audubon, IANTSB CHI65F0010Accident · No injuriesClosedCessna 150 · Wadsworth, OHNTSB LAX65D0026Accident · No injuriesClosedCessna 170B · Hawthorne, CA