Skip to content

Final NTSB investigations, 1978

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

Final NTSB investigations, 1978 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

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") = 1978 AND c."completionStatus" = 'Completed' 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\") = 1978
    AND c.\"completionStatus\" = 'Completed'
  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") = 1978
  AND c."completionStatus" = 'Completed'
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 OAK79FVW06Accident · No injuriesClosedBell 47J2A · Boulder City, NVDec 31, 1978 · N8523F · Substantial damage NTSB OAK79DVG09Accident · No injuriesClosedCessna 150 · Grass Valley, CADec 31, 1978 · N9124U · Substantial damage NTSB MIA79FA034Accident · 1 fatalClosedPiper PA-30 · Lafayette, GADec 31, 1978 · N7031Y · Destroyed NTSB LAX79DUJ39Accident · Serious injuriesClosedAeronca 0-58B · Flagstaff, AZDec 31, 1978 · N33323 · Substantial damage NTSB IAD79FA026Accident · 2 fatalClosedCessna 177B · Charlotte, NCDec 31, 1978 · N19580 · Destroyed NTSB UNK79X0108Accident · No injuriesClosedMooney M20F · Walker Cay, Burkina FasoDec 30, 1978 · N6913V · Substantial damage NTSB MKC79FTK06Accident · Serious injuriesClosedChampion 7ECA · Leola, SDDec 30, 1978 · N5142T · Substantial damage NTSB MIA79DLD30Accident · No injuriesClosedCessna 175 · Clearwater, FLDec 30, 1978 · N7521M · Substantial damage NTSB MIA79DLA13Accident · No injuriesClosedCessna 185 · Deland, FLDec 30, 1978 · N4544F · Substantial damage NTSB FTW79FA038Accident · 1 fatalClosedBeech C-90 · Houston, TXDec 30, 1978 · N2029N · Destroyed NTSB CHI79FA022Accident · 2 fatalClosedPiper PA-28R · Grissom Afb, INDec 30, 1978 · N3712T · Destroyed NTSB ANC79DAA04Accident · Minor injuriesClosedPiper PA-18 · Wild Lake, AKDec 30, 1978 · N9397D · Substantial damage NTSB OAK79DXQ09Accident · No injuriesClosedCessna 210 · Mammoth Lakes, CADec 29, 1978 · N777GB · Substantial damage NTSB NYC79FFJ07Accident · Minor injuriesClosedPiper PA-28 · Rochester, NYDec 29, 1978 · N55112 · Substantial damage NTSB MIA79FKJ18Accident · No injuriesClosedCessna 182 · Decatur, ALDec 29, 1978 · N1933X · Minor damage NTSB LAX79FA021Accident · 1 fatalClosedBeech 95-55 · Flagstaff, AZDec 29, 1978 · N6118V · Destroyed NTSB FTW79FPD05Accident · No injuriesClosedLuscombe 8A · Clifton, TXDec 29, 1978 · N45497 · Substantial damage NTSB FTW79FA037Accident · 2 fatalClosedCessna 172XP · Abilene, TXDec 29, 1978 · N758CA · Destroyed NTSB FTW79FA036Accident · 4 fatalClosedBeech 95-B55 · Lewisville, TXDec 29, 1978 · N608T · Destroyed NTSB FTW79FA035Accident · 1 fatalClosedBell BH212 · Galveston, TXDec 29, 1978 · N49591 · Destroyed NTSB DEN79DTM07Accident · No injuriesClosedPiper PA28R · Ruby'S Inn, UTDec 29, 1978 · N222TC · Substantial damage NTSB CHI79FEP20Accident · No injuriesClosedCessna 207 · Lyndon Station, WIDec 29, 1978 · N1688U · Substantial damage NTSB SEA79DYK04Accident · No injuriesClosedCessna 152 · Burns, ORDec 28, 1978 · N45989 · Substantial damage NTSB NYC79FNC15Accident · Serious injuriesClosedCessna 172N · Lebanon, NHDec 28, 1978 · N738LK · Substantial damage NTSB NYC79FGM13Accident · No injuriesClosedGrum Amer AA-5A · Somerset, PADec 28, 1978 · N26078 · Substantial damage NTSB NYC79FFA06Accident · No injuriesClosedCessna 172 · Albany, NYDec 28, 1978 · N3891S · Substantial damage NTSB NYC79DHD07Accident · Minor injuriesClosedCessna 172N · Robbinsville, NJDec 28, 1978 · N73749 · Substantial damage NTSB NYC79DFJ08Accident · No injuriesClosedPiper PA-23 · Weedsport, NYDec 28, 1978 · N6929Y · Substantial damage NTSB MKC79FCD07Accident · No injuriesClosedCessna 310Q · Waverly, IADec 28, 1978 · N728SC · Substantial damage NTSB MIA79FKA03Accident · No injuriesClosedCessna A185F · Aguadilla, PRDec 28, 1978 · N9373H · Substantial damage NTSB FTW79FRJ06Accident · Serious injuriesClosedCessna 152 · Bonita, LADec 28, 1978 · N49851 · Substantial damage NTSB FTW79FPA06Accident · No injuriesClosedCessna 310 · Sherman, TXDec 28, 1978 · N2615C · Substantial damage NTSB FTW79FA034Accident · 1 fatalClosedAero Comdr 680 · Oklahoma City, OKDec 28, 1978 · N6818S · Destroyed NTSB FTW79DPG13Accident · No injuriesClosedGrumman AA1-C · Strong, ARDec 28, 1978 · N9633U · Substantial damage NTSB DCA79AA005Accident · 10 fatalClosedDouglas DC-8 · Portland, ORDec 28, 1978 · N8082U · Destroyed NTSB CHI79FEX12Accident · No injuriesClosedCessna 152 · Bloomington, INDec 28, 1978 · N49417 · Substantial damage NTSB CHI79FEP13Accident · No injuriesClosedCessna 150 · Sussex, WIDec 28, 1978 · N60422 · Substantial damage NTSB CHI79FCA02Accident · No injuriesClosedMooney M20J · Belleville, ILDec 28, 1978 · N201RY · Substantial damage NTSB CHI79DEP17Accident · No injuriesClosedPiper PA-24 · Eau Claire, WIDec 28, 1978 · N6175P · Substantial damage NTSB CHI79DEE24Accident · No injuriesClosedSchuster WAS2 · Ottawa, ILDec 28, 1978 · N9120 · Substantial damage NTSB SEA79FTI05Accident · Minor injuriesClosedBell 214B-1 · Darby, MTDec 27, 1978 · N224RM · Substantial damage NTSB NYC79DNC14Accident · Serious injuriesClosedPiper PA-28 · Bennington, VTDec 27, 1978 · N6476J · Substantial damage NTSB MKC79DCQ07Accident · No injuriesClosedCessna 172 · Sedgwick, KSDec 27, 1978 · N6161E · Substantial damage NTSB MIA79FLD28Accident · No injuriesClosedBell 47J2A · Kissimmee, FLDec 27, 1978 · N3099G · Substantial damage NTSB MIA79FLD27Accident · No injuriesClosedBeech 95-B55 · Arcadia, FLDec 27, 1978 · N5716V · Substantial damage NTSB LAX79FA020Accident · 1 fatalClosedHughes 500DH · Mecca, CADec 27, 1978 · N501DH · Destroyed NTSB LAX79DUJ40Accident · No injuriesClosedCessna 150 · Tucson, AZDec 27, 1978 · N4816X · Substantial damage NTSB LAX79DUJ32Accident · No injuriesClosedCessna 152 · Phoenix, AZDec 27, 1978 · N25058 · Substantial damage NTSB LAX79DUJ25Accident · No injuriesClosedMidget Mustng · Prescott, AZDec 27, 1978 · N86DL · Substantial damage NTSB FTW79FQD04Accident · Serious injuriesClosedCessna 172N · Marfa, TXDec 27, 1978 · N739SS · Destroyed