Skip to content

NTSB investigations: Cessna 152, 1979

126 cases on aircraft the registry lists as Cessna 152. 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 152, 1979 per year, 1964–2026: 2,738 cases
1964	2
1969	1
1973	1
1975	1
1976	1
1977	18
1978	103
1979	126
1980	129
1981	151
1982	126
1983	124
1984	128
1985	120
1986	98
1987	126
1988	115
1989	107
1990	103
1991	88
1992	72
1993	82
1994	71
1995	71
1996	70
1997	61
1998	69
1999	56
2000	59
2001	49
2002	36
2003	28
2004	21
2005	33
2006	22
2007	23
2008	24
2009	25
2010	19
2011	10
2012	11
2013	19
2014	6
2015	11
2016	24
2017	14
2018	16
2019	16
2020	10
2021	7
2022	12
2023	7
2024	3
2025	7
2026	6

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") = 1979 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835')) 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\") = 1979
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835'))
  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") = 1979
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071835'))
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 CHI80FEC08Accident · No injuriesClosedCessna 152 · Frasher, MIDec 27, 1979 · N89969 · Substantial damage NTSB FTW80FRG16Accident · No injuriesClosedCessna 152 · San Antonio, TXDec 24, 1979 · N68816 · Substantial damage NTSB MKC80FA015Accident · 1 fatalClosedCessna 152 · Olathe, KSDec 21, 1979 · N25494 · Destroyed NTSB MIA80DKJ14Accident · No injuriesClosedCessna 152 · Huntsville, ALDec 21, 1979 · N67340 · Substantial damage NTSB LAX80DVD05Accident · No injuriesClosedCessna 152 · Santa Rosa, CADec 14, 1979 · N5085B · Substantial damage NTSB MIA80DLA11Accident · Minor injuriesClosedCessna 152 · Tallahassee, FLDec 13, 1979 · N24243 · Substantial damage NTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJDec 11, 1979 · N48470 · Substantial damage NTSB FTW80FRA12Accident · No injuriesClosedCessna 152 · Eagle Lake, TXDec 7, 1979 · N49190 · Destroyed NTSB MKC80DCG05Accident · No injuriesClosedCessna 152 · Lee'S Summit, MODec 6, 1979 · N24547 · Substantial damage NTSB MKC80DER14Accident · No injuriesClosedCessna 152 · Jackson, MNDec 4, 1979 · N24374 · Substantial damage NTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZDec 3, 1979 · N25763 · Destroyed NTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WADec 1, 1979 · N48129 · Substantial damage NTSB FTW80FPM05Accident · No injuriesClosedCessna 152 · Tulsa, OKDec 1, 1979 · N25475 · Substantial damage NTSB CHI80FEP07Accident · Minor injuriesClosedCessna 152 · Madison, WINov 29, 1979 · N714WL · Substantial damage NTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNov 27, 1979 · N48835 · Destroyed NTSB MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB SEA80FYM06Accident · Minor injuriesClosedCessna 152 · Newberg, ORNov 23, 1979 · N67500 · Substantial damage NTSB LAX80FA015Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 18, 1979 · N24906 · 2 aircraft · Substantial damage NTSB LAX80DJA04Accident · No injuriesClosedCessna 152 · Honolulu, HINov 18, 1979 · N89774 · Substantial damage NTSB LAX80DVD01Accident · No injuriesClosedCessna 152 · Santa Rosa, CANov 11, 1979 · N67708 · Substantial damage NTSB MKC80DCG01Accident · Minor injuriesClosedCessna 152 · Warrensburg, MONov 10, 1979 · N69206 · Substantial damage NTSB MIA80DLD08Accident · No injuriesClosedCessna 152 · Cedar Key, FLNov 9, 1979 · N24308 · Substantial damage NTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANov 7, 1979 · N757RA · Substantial damage NTSB CHI80FEC02Accident · No injuriesClosedCessna 152 · Jackson, MINov 6, 1979 · N68246 · Substantial damage NTSB LAX80DVM05Accident · Minor injuriesClosedCessna 152 · Oceano, CANov 4, 1979 · N757TG · Destroyed NTSB NYC80FA008Accident · 1 fatalClosedCessna 152 · New Bedford, MAOct 31, 1979 · N757ZW · Destroyed NTSB NYC80FGM05Accident · Minor injuriesClosedCessna 152 · Jeannette, PAOct 30, 1979 · N757FN · Substantial damage NTSB MIA80DLD02Accident · No injuriesClosedCessna 152 · Sebastian, FLOct 28, 1979 · N64923 · Destroyed NTSB MIA80DKT09Accident · Minor injuriesClosedCessna 152 · Highland Beach, FLOct 27, 1979 · N89705 · Substantial damage NTSB NYC80FHM01Accident · No injuriesClosedCessna 152 · East Hanover, NJOct 23, 1979 · N65601 · Substantial damage NTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WIOct 19, 1979 · N714VN · Substantial damage NTSB LAX80FUD02Accident · No injuriesClosedCessna 152 · Hawthorne, CAOct 17, 1979 · N67522 · Substantial damage NTSB MIA80FKG03Accident · No injuriesClosedCessna 152 · Snellville, GAOct 13, 1979 · N67825 · Substantial damage NTSB LAX80FA007Accident · 2 fatalClosedCessna 152 · Ojai, CAOct 13, 1979 · N49216 · Destroyed NTSB IAD80DLQ03Accident · No injuriesClosedCessna 152 · Bowling Green, KYOct 13, 1979 · N47109 · Substantial damage NTSB NYC80FGM02Accident · No injuriesClosedCessna 152 · Butler, PAOct 6, 1979 · N64932 · Substantial damage NTSB UNK80X0100Accident · 2 fatalClosedCessna 152 · Gainesville, TXOct 1, 1979 · N4739B · Destroyed NTSB LAX80DUJ04Accident · No injuriesClosedCessna 152 · Springerville, AZOct 1, 1979 · N714XW · Substantial damage NTSB CHI80DA003Accident · 1 fatalClosedCessna 152 · Syracuse, INOct 1, 1979 · N89179 · Destroyed NTSB CHI7.FEP81Accident · Minor injuriesClosedCessna 152 · Rio, WISep 28, 1979 · N714SY · Substantial damage NTSB SEA79DYE46Accident · No injuriesClosedCessna 152 · Rochester, WASep 16, 1979 · N68267 · Substantial damage NTSB MKC79DCD40Accident · No injuriesClosedCessna 152 · Oxford, IASep 12, 1979 · N65465 · Substantial damage NTSB FTW79DPA28Accident · No injuriesClosedCessna 152 · Corsicana, TXSep 10, 1979 · N25281 · Substantial damage NTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INSep 9, 1979 · N24489 · Substantial damage NTSB MIA79DLD96Accident · No injuriesClosedCessna 152 · Lutz, FLSep 8, 1979 · N47009 · Substantial damage NTSB SEA79FYK28Accident · No injuriesClosedCessna 152 · Creswell, ORSep 7, 1979 · N89487 · Substantial damage NTSB CHI79DEC53Accident · No injuriesClosedCessna 152 · Detroit, MISep 1, 1979 · N25800 · Substantial damage NTSB CHI79CEM38Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 30, 1979 · N68339 · Substantial damage NTSB MKC79DCD35Accident · No injuriesClosedCessna 152 · Mt Pleasant, IAAug 27, 1979 · N24366 · Substantial damage NTSB DEN79FTE77Accident · Minor injuriesClosedCessna 152 · Center, COAug 27, 1979 · N24967 · Substantial damage