Skip to content

NTSB investigations, 1979

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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

NTSB investigations, 1979 per year, 1962–2026: 180,581 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,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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 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
  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
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 MIA80FLD25Accident · No injuriesClosedCessna 210 · Odessa, FLDec 31, 1979 · N6465N · Substantial damage NTSB MIA80FKJ15Accident · No injuriesClosedCessna 172I · Foley, ALDec 31, 1979 · N46053 · Substantial damage NTSB LAX80DVW08Accident · No injuriesClosedCessna 310F · Boulder City, NVDec 31, 1979 · N6769X · Substantial damage NTSB IAD80FLQ07Accident · Serious injuriesClosedPiper PA-28R · Whitesburg, KYDec 31, 1979 · N5061S · Substantial damage NTSB NYC80FHJ06Accident · Minor injuriesClosedCougar AJ1 · Bayport, NYDec 30, 1979 · N11112 · Substantial damage NTSB NYC80FA017Accident · 2 fatalClosedCessna 172N · Lindenhurst, NYDec 30, 1979 · N738WX · Destroyed NTSB NYC80DFJ02Accident · No injuriesClosedSchweizer SGS126 · Elmira, NYDec 30, 1979 · N2508H · Substantial damage NTSB MIA80FLA09Accident · No injuriesClosedPiper PA-23 · Jacksonville, FLDec 30, 1979 · N1063P · Substantial damage NTSB IAD80DID07Accident · No injuriesClosedLuscombe 8E · Indian Valley, VADec 30, 1979 · N45765 · Substantial damage NTSB DEN80DTE17Accident · No injuriesClosedCessna 150M · Peyton, CODec 30, 1979 · N9424U · Substantial damage NTSB CHI80FEX03Accident · Minor injuriesClosedBeech B35 · Fairmount, INDec 30, 1979 · N8811A · Substantial damage NTSB CHI80FA020Accident · 3 fatalClosedPiper PA-28 · Royal Oak, MIDec 30, 1979 · N4512P · Destroyed NTSB ANC80DAG22Accident · No injuriesClosedHelio Acft H-250 · Anchorage, AKDec 30, 1979 · N5460E · Substantial damage NTSB SEA80FTA07Accident · 1 fatalClosedScorpion 133 · Nashua, MTDec 29, 1979 · NONE · Destroyed NTSB NYC80FNE07Accident · No injuriesClosedCessna 172 · Burlington, CTDec 29, 1979 · N2416L · Substantial damage NTSB NYC80FHM06Accident · Serious injuriesClosedCessna 150 · Teaneck, NJDec 29, 1979 · N50741 · Substantial damage NTSB NYC80FHJ08Accident · No injuriesClosedPiper PA-28 · Amityville, NYDec 29, 1979 · N4372J · Substantial damage NTSB MIA80FLD26Accident · No injuriesClosedPitts S-1C · Odessa, FLDec 29, 1979 · N8NS · Substantial damage NTSB IAD80DLJ06Accident · No injuriesClosedBaby GRT LK 1 · Durham, NCDec 29, 1979 · N1BL · Substantial damage NTSB CHI80FEK06Accident · No injuriesClosedGrumman AA1-B · Lima, OHDec 29, 1979 · N1445R · Substantial damage NTSB CHI80DEP12Accident · No injuriesClosedM.B.B. BO-209 · Johnson Creek, WIDec 29, 1979 · N209SF · Substantial damage NTSB CHI80DEP11Accident · No injuriesClosedPiper PA-28 · Rio Creek, WIDec 29, 1979 · N15651 · Substantial damage NTSB NYC80FA016Accident · 2 fatalClosedPiper PA-28 · Broad Brook, CTDec 28, 1979 · N16436 · Destroyed NTSB LAX80DVG12Accident · Minor injuriesClosedAir Tractor AT-301 · Woodland, CADec 28, 1979 · N87695 · Substantial damage NTSB IAD80DIG04Accident · No injuriesClosedSchleicher KA-7 · Lavale, MDDec 28, 1979 · N1047Z · Substantial damage NTSB FTW80DRD13Accident · No injuriesClosedCessna 185 · Morgan City, LADec 28, 1979 · N185M · Substantial damage NTSB DEN80FTE16Accident · Minor injuriesClosedCessna 150 · Paonia, CODec 28, 1979 · N50089 · Substantial damage NTSB DEN80FA016Accident · 1 fatalClosedBeech B60 · Hayden, CODec 28, 1979 · N6030S · Destroyed NTSB DEN80DTC04Accident · No injuriesClosedBell 206B · Thermopolis, WYDec 28, 1979 · N16867 · Substantial damage NTSB CHI80FA019Accident · 2 fatalClosedPiper PA-28R · Kankakee, ILDec 28, 1979 · N7644J · Destroyed NTSB UNK80X0104Accident · No injuriesClosedBoeing 747 · London, United KingdomDec 27, 1979 · N771PA · Substantial damage NTSB MKC80DER16Accident · Minor injuriesClosedBellanca 7ECA · Paynesville, MNDec 27, 1979 · N3086H · Destroyed NTSB MIA80IA103Incident · No injuriesClosedDouglas DC3C · St Thomas, VIDec 27, 1979 · N100SD · Minor damage NTSB LAX80DVG11Accident · No injuriesClosedCessna 172RG · Grass Valley, CADec 27, 1979 · N5552R · Substantial damage NTSB FTW80FPG09Accident · Minor injuriesClosedPiper PA-28 · N Little Rock, ARDec 27, 1979 · N5931W · Substantial damage NTSB CHI80FEC08Accident · No injuriesClosedCessna 152 · Frasher, MIDec 27, 1979 · N89969 · Substantial damage NTSB LAX80FVW07Accident · Serious injuriesClosedPiper PA-24 · Las Vegas, NVDec 26, 1979 · N7253P · Substantial damage NTSB FTW80FRD12Accident · Serious injuriesClosedAerospatle AS-350 · Intracstl Cy, LADec 26, 1979 · N3594B · Substantial damage NTSB FTW80DPM06Accident · Minor injuriesClosedMaule M-5 · Vinitta, OKDec 26, 1979 · N51624 · Substantial damage NTSB FTW80DPD08Accident · No injuriesClosedCessna 172 · Denton, TXDec 26, 1979 · N75510 · Substantial damage NTSB DEN79FA015Accident · 5 fatalClosedCessna 421B · Eagle.Co, CODec 26, 1979 · N100RV · Destroyed NTSB CHI80FEM09Accident · No injuriesClosedCessna 150H · Hesperia, MIDec 26, 1979 · N6746S · Substantial damage NTSB SEA80DYM11Accident · No injuriesClosedCessna 177RG · Hood River, ORDec 25, 1979 · N2185Q · Substantial damage NTSB MIA80FLA13Accident · Minor injuriesClosedBeech C-23 · Jacksonville, FLDec 25, 1979 · N5171M · Substantial damage NTSB LAX80FUA06Accident · No injuriesClosedPiper PA-22 · Dana Point, CADec 25, 1979 · N3328Z · Substantial damage NTSB FTW80FRG16Accident · No injuriesClosedCessna 152 · San Antonio, TXDec 24, 1979 · N68816 · Substantial damage NTSB CHI80DEM10Accident · Minor injuriesClosedPiper PA-20 · Ithaca, MIDec 24, 1979 · N2807Z · Substantial damage NTSB MKC80FTG02Accident · Serious injuriesClosedBeech C35 · Grand Forks, NDDec 23, 1979 · N692D · Substantial damage NTSB MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSDec 23, 1979 · N7253M · Destroyed NTSB LAX80FVM11Accident · No injuriesClosedCessna 172 · Salinas, CADec 23, 1979 · N73138 · Substantial damage