NTSB investigations: Cessna 150K, 1976
19 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\") = 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 ('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") = 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 ('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 IAD77DID10Accident · No injuriesClosedCessna 150 · Emporia, VANTSB LAX77PUJ13Accident · No injuriesClosedCessna 150 · Parker, AZNTSB MIA76FKK04Accident · No injuriesClosedCessna 150 · Pell City, ALNTSB LAX76FUG70Accident · Serious injuriesClosedCessna 150K · Wrightwood, CANTSB IAD76AI094Accident · 1 fatalClosedCessna 150H · Petersburg, VANTSB NYC76FNE32Accident · No injuriesClosedCessna 150 · Ellington, CTNTSB NYC76FHA47Accident · Minor injuriesClosedCessna 150K · Hillsboro, NJNTSB IAD76FID36Accident · No injuriesClosedCessna 150K · Hopewell, VANTSB IAD76DKW36Accident · No injuriesClosedCessna 150 · Lawrenceburg, TNNTSB CHI76AC071Accident · 1 fatalClosedCessna 150K · Corunna, INNTSB CHI76DET42Accident · No injuriesClosedCessna 150 · Woodburn, INNTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARNTSB MIA76FKG55Accident · No injuriesClosedCessna 150K · Fayetteville, GANTSB FTW76DRA31Accident · No injuriesClosedCessna 150 · Lagrange, TXNTSB LAX76DVA53Accident · No injuriesClosedCessna 150K · Bakersfield, CANTSB MIA76DKT66Accident · No injuriesClosedCessna 150 · Key Largo, FLNTSB FTW76DRG40Accident · No injuriesClosedCessna 150 · Kingsland, TXNTSB IAD76DKM28Accident · No injuriesClosedCessna 150 · Denton, NCNTSB LAX76AL046Accident · 3 fatalClosedCessna 150K · Irvine, CA