Skip to content

NTSB investigations: Cessna 150, 1964

61 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, 1964 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKDec 27, 1964 · N5779E · Substantial damage NTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · Destroyed NTSB UNK65X1056Accident · No injuriesClosedCessna 150 · San Carlos, CADec 19, 1964 · N5973E · 2 aircraft · Substantial damage NTSB UNK65X1007Accident · 1 fatalClosedCessna 120 · Anaheim, CADec 13, 1964 · N1708V · 2 aircraft · Substantial damage NTSB UNK65X0965Accident · No injuriesClosedCessna 150 · Lima, OHDec 10, 1964 · N5879E · Substantial damage NTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MIDec 8, 1964 · N5673E · Substantial damage NTSB UNK65X0882Accident · No injuriesClosedCessna 150 · San Bernardino, CANov 29, 1964 · N7965E · Substantial damage NTSB UNK65X0798Accident · No injuriesClosedCessna 150 · Agawam, MANov 22, 1964 · N5889E · Substantial damage NTSB UNK65X0589Accident · No injuriesClosedCessna 150 · Hopewell Jct, NYNov 7, 1964 · N5621E · Destroyed NTSB UNK65X0532Accident · No injuriesClosedCessna 150 · Hawthorne, CANov 2, 1964 · N7771E · Substantial damage NTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WAOct 29, 1964 · N7942E · Destroyed NTSB UNK65X0459Accident · No injuriesClosedCessna 150 · Colts Neck, NJOct 28, 1964 · N5990E · Substantial damage NTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PAOct 25, 1964 · N7766E · Substantial damage NTSB UNK65X0414Accident · 2 fatalClosedCessna 150 · Fort Collins, COOct 24, 1964 · N7869E · Destroyed NTSB UNK65X0221Accident · No injuriesClosedCessna 150 · Hanson, MAOct 10, 1964 · N7728E · Substantial damage NTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PAOct 5, 1964 · N6560T · Substantial damage NTSB UNK64X4009Accident · No injuriesClosedCessna 150 · Hanover, NJSep 16, 1964 · N7791E · Substantial damage NTSB UNK64X3845Accident · No injuriesClosedCessna 150 · Bayport, NYSep 7, 1964 · N1298Y · Destroyed NTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WAAug 29, 1964 · N516RA · Destroyed NTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damage NTSB UNK64X3567Accident · 2 fatalClosedCessna 150 · Fillmore, CAAug 23, 1964 · N139SF · Destroyed NTSB UNK64X3496Accident · No injuriesClosedCessna 150 · Waynesboro, VAAug 20, 1964 · N7318X · Destroyed NTSB UNK64X3452Accident · No injuriesClosedCessna 150 · Denver, COAug 18, 1964 · N7758E · Substantial damage NTSB UNK64X3398Accident · No injuriesClosedCessna 150 · Frankfort, KSAug 15, 1964 · N5539E · Substantial damage NTSB UNK64X3293Accident · No injuriesClosedCessna 150 · Asbury Park, NJAug 9, 1964 · N5708E · Substantial damage NTSB UNK64X3012Accident · Minor injuriesClosedCessna 150 · Ducktown, TNJul 24, 1964 · N7921E · Destroyed NTSB UNK64X2750Accident · Minor injuriesClosedCessna 150 · Ambler, PAJul 10, 1964 · N7969E · Destroyed NTSB UNK64X2724Accident · No injuriesClosedCessna 150 · Minerva, OHJul 9, 1964 · N7990E · Substantial damage NTSB UNK64X2666Accident · No injuriesClosedCessna 150 · Santa Susana, CAJul 5, 1964 · N7827E · Substantial damage NTSB UNK64X2644Accident · No injuriesClosedCessna 150 · Pacoima, CAJul 4, 1964 · N5668E · Substantial damage NTSB UNK64X2561Accident · 2 fatalClosedCessna 150 · New Richmond, INJun 29, 1964 · N7806E · Destroyed NTSB UNK64X2395Accident · No injuriesClosedCessna 150 · Dayton, OHJun 20, 1964 · N5994E · Substantial damage NTSB UNK64X2291Accident · No injuriesClosedCessna 150 · Roswell, NMJun 14, 1964 · N7790E · Substantial damage NTSB UNK64X2127Accident · No injuriesClosedCessna 150 · Sussex, NJJun 5, 1964 · N5739E · Substantial damage NTSB UNK64X1935Accident · No injuriesClosedCessna 150 · S Branch, MIMay 24, 1964 · N5874E · Substantial damage NTSB UNK64X1892Accident · No injuriesClosedCessna 150D · Aberdeen, OHMay 23, 1964 · N4365U · Substantial damage NTSB UNK64X1883Accident · No injuriesClosedCessna 150 · Northhampton, MAMay 22, 1964 · N6492T · Substantial damage NTSB UNK64X1845Accident · No injuriesClosedCessna 150 · W Carrollton, OHMay 19, 1964 · N7958E · Substantial damage NTSB UNK64X1729Accident · 1 fatalClosedCessna 150 · Gastonia, NCMay 11, 1964 · N7721E · Destroyed NTSB UNK64X1682Accident · No injuriesClosedCessna 150 · Chattanooga, OKMay 9, 1964 · N5965E · Substantial damage NTSB UNK64X1635Accident · No injuriesClosedCessna 150 · Muskegon, MIMay 6, 1964 · N5906E · Substantial damage NTSB UNK64X1598Accident · No injuriesClosedCessna 150 · Clayton, INMay 3, 1964 · N5517E · Substantial damage NTSB UNK64X1455Accident · No injuriesClosedCessna 150 · Milwaukee, WIApr 25, 1964 · N6529T · Substantial damage NTSB UNK64X1309Accident · No injuriesClosedCessna 150 · Auburn, CAApr 14, 1964 · N5510E · Substantial damage NTSB UNK64X1301Accident · No injuriesClosedCessna 150 · Dallas, TXApr 13, 1964 · N5667E · Substantial damage NTSB UNK64X1245Accident · No injuriesClosedCessna 150 · Bishop, CAApr 10, 1964 · N6539T · Substantial damage NTSB UNK64X1205Accident · No injuriesClosedCessna 150 · Vega Baja, PRApr 6, 1964 · N7903E · Substantial damage NTSB UNK64X1007Accident · Minor injuriesClosedCessna 150 · St Joseph, MOMar 21, 1964 · N6548T · Destroyed NTSB UNK64X0961Accident · No injuriesClosedCessna 150 · Pearland, TXMar 17, 1964 · N5864E · Substantial damage NTSB UNK64X0941Accident · No injuriesClosedCessna 150 · Capistrano, CAMar 15, 1964 · N7827E · Substantial damage