Skip to content

NTSB investigations: Cessna 150, 1966

53 cases on aircraft the registry lists as Cessna 150. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Cessna 150, 1966 per year, 1964–2026: 488 cases
1964	61
1965	41
1966	53
1967	28
1968	28
1969	25
1970	20
1971	15
1972	23
1973	24
1974	16
1975	16
1976	11
1977	15
1978	8
1979	4
1980	6
1981	2
1982	6
1983	2
1984	2
1985	1
1986	2
1988	4
1989	6
1990	2
1991	6
1992	7
1993	2
1994	3
1995	3
1996	1
1997	2
1998	5
1999	1
2000	3
2001	3
2002	1
2003	1
2004	5
2005	1
2006	3
2007	4
2010	1
2012	2
2013	1
2015	1
2016	2
2018	2
2021	1
2022	2
2023	3
2025	1

Where

Latest cases

Query with SQL

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 ('2071802')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2071802'))
  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 ('2071802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC67F0444Accident · No injuriesClosedCessna 150 · Broadbrook, CTDec 23, 1966 · N5558E · Substantial damage NTSB MKC67F0344Accident · No injuriesClosedCessna 150 · Cleveland, NDDec 22, 1966 · N5912E · Substantial damage NTSB CHI67F0378Accident · No injuriesClosedCessna 150 · Angola, INNov 26, 1966 · N6497T · Destroyed NTSB OAK67A0048Accident · 1 fatalClosedCessna 150 · San Jose, CANov 5, 1966 · N5653E · Destroyed NTSB DEN67F0134Accident · No injuriesClosedCessna 150 · Denver, COOct 24, 1966 · N7979E · Substantial damage NTSB FTW67F0278Accident · No injuriesClosedCessna 150E · Killeen, TXOct 22, 1966 · N6233R · Substantial damage NTSB CHI67D0276Accident · No injuriesClosedCessna 150 · Grove City, OHOct 9, 1966 · N7872Z · Substantial damage NTSB LAX67F0140Accident · No injuriesClosedCessna 150 · Huntingtn Bch, CAOct 7, 1966 · N6495T · Substantial damage NTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PAOct 2, 1966 · N7834E · Substantial damage NTSB SEA67D0159Accident · Minor injuriesClosedCessna 150 · Avery, IDOct 1, 1966 · N5812E · Destroyed NTSB DEN67D0149Accident · No injuriesClosedCessna 150 · Artesia, COSep 28, 1966 · N5747E · Substantial damage NTSB FTW67F0218Accident · Minor injuriesClosedCessna 150 · Presidio, TXSep 22, 1966 · N5855E · Destroyed NTSB OAK67D0103Accident · No injuriesClosedCessna 150 · Fresno, CASep 7, 1966 · N7742E · Substantial damage NTSB OAK67F0091Accident · Serious injuriesClosedCessna 150 · Al Tahoe, CAAug 13, 1966 · N5510E · Destroyed NTSB OAK67D0118Accident · No injuriesClosedCessna 150 · Millbrae, CAAug 3, 1966 · N8168F · Substantial damage NTSB CHI67F0128Accident · No injuriesClosedCessna 150 · Big Rapids, MIJul 20, 1966 · N5791E · Substantial damage NTSB NYC67F0073Accident · No injuriesClosedCessna 150 · Scarboro, MEJul 17, 1966 · N6508T · Substantial damage NTSB FTW67D0093Accident · No injuriesClosedCessna 150 · Austin, TXJul 13, 1966 · N6421T · Substantial damage NTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDJul 12, 1966 · N7811E · Substantial damage NTSB FTW67D0084Accident · No injuriesClosedCessna 150 · Blue Mound, TXJul 5, 1966 · N7896E · Substantial damage NTSB SEA67F0084Accident · No injuriesClosedCessna 150 · Cottage Grove, ORJul 4, 1966 · N6604T · Substantial damage NTSB LAX67D0052Accident · No injuriesClosedCessna 150 · Acton, CAJun 27, 1966 · N5739E · Substantial damage NTSB FTW67D0044Accident · No injuriesClosedCessna 150 · Cordell, OKJun 26, 1966 · N7825E · Substantial damage NTSB CHI67D0063Accident · No injuriesClosedCessna 150 · Carmel, INJun 25, 1966 · N5535E · Substantial damage NTSB DEN67D0009Accident · No injuriesClosedCessna 150 · Meeker, COJun 23, 1966 · N5658E · Substantial damage NTSB SEA67D0014Accident · No injuriesClosedCessna 150 · Richland, WAJun 18, 1966 · N7794E · Substantial damage NTSB NYC67D0005Accident · No injuriesClosedCessna 150 · Neffsville, PAJun 8, 1966 · N8806S · Substantial damage NTSB OAK67D0072Accident · No injuriesClosedCessna 150 · Las Vegas, NVJun 5, 1966 · N5638E · Substantial damage NTSB CHI66A0092Accident · 1 fatalClosedCessna 150 · No.Jackson, OHMay 25, 1966 · N4143U · Destroyed NTSB SEA67D0050Accident · No injuriesClosedCessna 150 · Beaverton, ORMay 19, 1966 · N5611E · Substantial damage NTSB SEA67F0043Accident · No injuriesClosedCessna 150 · Chehalis, WAMay 17, 1966 · N5972E · Substantial damage NTSB FTW66F0657Accident · No injuriesClosedCessna 150 · Dallas, TXMay 4, 1966 · N7941E · Substantial damage NTSB MIA66F0529Accident · No injuriesClosedCessna 150 · Franklinton, NCMay 1, 1966 · N7784E · Destroyed NTSB LAX66F0319Accident · No injuriesClosedCessna 150 · Van Nuys, CAApr 29, 1966 · N6534T · Substantial damage NTSB LAX66D0297Accident · No injuriesClosedCessna 150 · Palm Springs, CAApr 8, 1966 · N6053T · Substantial damage NTSB LAX66F0288Accident · No injuriesClosedCessna 150 · Van Nuys, CAApr 2, 1966 · N6414T · Substantial damage NTSB OAK66A0042Accident · 1 fatalClosedCessna 150 · San Jose, CAMar 27, 1966 · N6423T · Destroyed NTSB OAK66F0245Accident · Minor injuriesClosedCessna 150 · Honolulu, HIMar 16, 1966 · N6473T · Substantial damage NTSB NYC66D0541Accident · No injuriesClosedCessna 150 · Whitesville, NJMar 16, 1966 · N5990E · Substantial damage NTSB NYC66A0100Accident · 2 fatalClosedCessna 150 · Waltham, MAMar 16, 1966 · N2063Z · Destroyed NTSB MKC66D0526Accident · No injuriesClosedCessna 150 · Hibbing, MNMar 14, 1966 · N5999T · Substantial damage NTSB DEN66F0721Accident · Serious injuriesClosedCessna 150 · Las Cruces, NMMar 14, 1966 · N6592T · Destroyed NTSB FTW66A0077Accident · 2 fatalClosedCessna 150 · Houston, TXMar 6, 1966 · N7927E · Destroyed NTSB DEN66D0301Accident · No injuriesClosedCessna 150 · Hotchkiss, COFeb 25, 1966 · N3074J · Substantial damage NTSB SEA66D0215Accident · No injuriesClosedCessna 150 · Council, IDFeb 20, 1966 · N5822E · Substantial damage NTSB NYC66F0508Accident · No injuriesClosedCessna 150 · New Cumberland, PAFeb 12, 1966 · N7842E · Substantial damage NTSB MIA66D0418Accident · Minor injuriesClosedCessna 150 · Homestead, FLFeb 2, 1966 · N5768E · Substantial damage NTSB OAK66F0192Accident · Minor injuriesClosedCessna 150 · Monterey, CAJan 22, 1966 · N6488T · Destroyed NTSB SEA66F0253Accident · Serious injuriesClosedCessna 150 · Seattle, WAJan 20, 1966 · N5718E · Substantial damage NTSB LAX66D0210Accident · No injuriesClosedCessna 150 · Santa Paula, CAJan 16, 1966 · N7774E · Substantial damage