NTSB investigations: Cessna 150G, 1976
36 cases on aircraft the registry lists as Cessna 150G. 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 | 1 |
|---|---|
| 1966 | 26 |
| 1967 | 154 |
| 1968 | 122 |
| 1969 | 114 |
| 1970 | 83 |
| 1971 | 78 |
| 1972 | 57 |
| 1973 | 47 |
| 1974 | 30 |
| 1975 | 41 |
| 1976 | 36 |
| 1977 | 22 |
| 1978 | 26 |
| 1979 | 22 |
| 1980 | 24 |
| 1981 | 12 |
| 1982 | 14 |
| 1983 | 15 |
| 1984 | 12 |
| 1985 | 14 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 10 |
| 1989 | 8 |
| 1990 | 16 |
| 1991 | 15 |
| 1992 | 11 |
| 1993 | 13 |
| 1994 | 6 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 3 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 4 |
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\") = 1976
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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") = 1976
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PANTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARNTSB FTW77DRG21Accident · Minor injuriesClosedCessna 150 · Mason, TXNTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CANTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDNTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INNTSB MIA77DKJ06Accident · Minor injuriesClosedCessna 150 · Eufaula, ALNTSB SEA77DYA05Accident · Minor injuriesClosedCessna 150 · Blackfoot, IDNTSB MIA77FLD11Accident · No injuriesClosedCessna 150G · Riverview, FLNTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMNTSB ANC76AA130Accident · 3 fatalClosedCessna 150 · Wrangell, AKNTSB OAK76DVD56Accident · Minor injuriesClosedCessna 150 · Concord, CANTSB CHI76FEV60Accident · Minor injuriesClosedCessna 150G · Pekin, ILNTSB MIA76DLA58Accident · No injuriesClosedCessna 150 · Pensacola, FLNTSB FTW76AF108Accident · 1 fatalClosedCessna 150G · Aubrey, TXNTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSNTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GANTSB NYC76DNA40Accident · Minor injuriesClosedCessna 150 · Shirley, MANTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYNTSB OAK76DXQ51Accident · No injuriesClosedCessna 150 · Reno, NVNTSB LAX76FUA25Accident · No injuriesClosedCessna 150 · Fullerton, CANTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WINTSB NYC76DNC38Accident · No injuriesClosedCessna 150 · Lincoln, MENTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSNTSB OAK76AP046Accident · 2 fatalClosedCessna 150G · Salinas, CANTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MANTSB CHI76FEC28Accident · No injuriesClosedCessna 150G · Petersburg, MINTSB MKC76FCD27Accident · Minor injuriesClosedCessna 150 · Davenport, IANTSB LAX76AL057Accident · 1 fatalClosedCessna 150G · Flagstaff, AZNTSB FTW76DPD30Accident · No injuriesClosedCessna 150 · Mineral Wells, TXNTSB NYC76DFJ16Accident · No injuriesClosedCessna 150 · West Monroe, NYNTSB FTW76DQD12Accident · Minor injuriesClosedCessna 150 · Coyanosa, TXNTSB NYC76AN073Accident · 2 fatalClosedCessna 150 · Bridgeport, CTNTSB NYC76FFA26Accident · No injuriesClosedCessna 150G · Cadyville, NYNTSB SEA76FYG29Accident · Serious injuriesClosedCessna 150 · Spokane, WANTSB DEN76DTE47Accident · No injuriesClosedCessna 150 · Craig, CO