NTSB investigations: Cessna 150K, 1978
17 cases on aircraft the registry lists as Cessna 150K. 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 | 3 |
|---|---|
| 1970 | 33 |
| 1971 | 51 |
| 1972 | 40 |
| 1973 | 36 |
| 1974 | 38 |
| 1975 | 24 |
| 1976 | 19 |
| 1977 | 12 |
| 1978 | 17 |
| 1979 | 9 |
| 1980 | 13 |
| 1981 | 13 |
| 1982 | 3 |
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 3 |
| 1986 | 8 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 9 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 5 |
| 2004 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2023 | 3 |
| 2024 | 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\") = 1978
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071822'))
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") = 1978
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071822'))
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 NYC79FNA08Accident · Minor injuriesClosedCessna 150K · Stow, MANTSB CHI79DEE13Accident · No injuriesClosedCessna 150 · Lanark, ILNTSB CHI78DEP60Accident · No injuriesClosedCessna 150K · Kenosha, WINTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARNTSB IAD78FID18Accident · Serious injuriesClosedBellanca 8KCAB · Norfolk, VANTSB OAK78DVG61Accident · Minor injuriesClosedCessna 150 · Paradise, CANTSB IAD78FLQ22Accident · Serious injuriesClosedCessna 150K · Russell Spgs, KYNTSB CHI78FEM21Accident · Serious injuriesClosedCessna 150K · Gladstone, MINTSB NYC78FHA23Accident · No injuriesClosedCessna 150 · Allentown, PANTSB MIA78FKG36Accident · No injuriesClosedCessna 150 · Covington, GANTSB DEN78FQA12Accident · Serious injuriesClosedCessna 150 · Albuquerque, NMNTSB IAD78FID06Accident · No injuriesClosedCessna 150 · Norfolk, VANTSB NYC78DNC18Accident · No injuriesClosedCessna 150 · Colebrook, NHNTSB MKC78FTG03Accident · No injuriesClosedCessna 150K · Cavalier, NDNTSB NYC78FNC14Accident · 2 fatalClosedCessna 150K · Dexter, MENTSB FTW78DRG24Accident · No injuriesClosedCessna 150 · San Antonio, TXNTSB OAK78DXQ07Accident · Minor injuriesClosedCessna 150 · Pyramid Lake, NV