NTSB investigations: Cessna 150A, 1966
21 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\") = 1966
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") = 1966
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 FTW67F0306Accident · No injuriesClosedCessna 150A · Abilene, TXNTSB FTW67F0323Accident · No injuriesClosedCessna 150 · San Antonio, TXNTSB MKC67F0358Accident · Minor injuriesClosedCessna 150A · Tioga, NDNTSB FTW67D0256Accident · No injuriesClosedCessna 150 · Pearsall, TXNTSB MKC67F0272Accident · No injuriesClosedCessna 150 · Rosemount, MNNTSB CHI67D0195Accident · No injuriesClosedCessna 150A · Stevens Point, WINTSB NYC67D0170Accident · No injuriesClosedCessna 150 · Westford, CTNTSB LAX67A0018Accident · 1 fatalClosedCessna 150A · S.Catalina Is., CANTSB NYC67D0084Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB MIA67D0049Accident · No injuriesClosedCessna 150 · Fayetteville, GANTSB LAX66F0371Accident · No injuriesClosedCessna 150 · Lompoc, CANTSB LAX66D0361Accident · No injuriesClosedCessna 150 · Ojai, CANTSB NYC66D0671Accident · No injuriesClosedCessna 150 · Mt.Pocono, PANTSB FTW67F0002Accident · Minor injuriesClosedCessna 150 · Arren, ARNTSB DEN66F0252Accident · No injuriesClosedCessna 150 · Broomfield, CONTSB LAX66F0242Accident · No injuriesClosedCessna 150 · Lompoc, CANTSB LAX66F0245Accident · Minor injuriesClosedCessna 150 · San Diego, CANTSB LAX66D0227Accident · No injuriesClosedCessna 150 · Burbank, CANTSB SEA66D0206Accident · No injuriesClosedCessna 150 · Scappoose, ORNTSB MIA66F0549Accident · No injuriesClosedCessna 150 · Pensacola, FLNTSB ANC66A0085Accident · Minor injuriesClosedCessna 150 · Anchorage, AK