Skip to content

NTSB investigations, 1979, MD

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

NTSB investigations, 1979, MD per year, 1962–2026: 1,679 cases
1962	2
1963	1
1964	76
1965	81
1966	68
1967	72
1968	52
1969	69
1970	56
1971	39
1972	36
1973	35
1974	35
1975	32
1976	40
1977	41
1978	31
1979	29
1980	25
1981	22
1982	29
1983	34
1984	28
1985	30
1986	26
1987	32
1988	25
1989	33
1990	29
1991	21
1992	25
1993	16
1994	18
1995	24
1996	27
1997	25
1998	20
1999	24
2000	18
2001	19
2002	12
2003	12
2004	11
2005	11
2006	19
2007	13
2008	20
2009	13
2010	21
2011	23
2012	10
2013	15
2014	13
2015	20
2016	10
2017	14
2018	12
2019	17
2020	12
2021	10
2022	17
2023	8
2024	7
2025	5
2026	9

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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
  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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA'
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 IAD80DIG04Accident · No injuriesClosedSchleicher KA-7 · Lavale, MDDec 28, 1979 · N1047Z · Substantial damage NTSB IAD80FIG03Accident · No injuriesClosedPiper PA-28 · Edgewater, MDDec 12, 1979 · N8132R · Substantial damage NTSB IAD80FA012Accident · 1 fatalClosedBellanca 8KCAB · Churchton, MDNov 25, 1979 · N444HG · Destroyed NTSB IAD80FIG02Accident · No injuriesClosedPiper PA-28 · Grasonville, MDNov 18, 1979 · N2889G · Substantial damage NTSB IAD80FIG01Accident · Serious injuriesClosedBushby Mini Mustng · Stevensville, MDOct 21, 1979 · N3794 · Substantial damage NTSB IAD79FA086Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDSep 20, 1979 · N11593 · Substantial damage NTSB IAD79DA084Accident · No injuriesClosedPiper PA-18 · Stevensville, MDSep 18, 1979 · N7233K · Substantial damage NTSB IAD79FA083Accident · No injuriesClosedHughes 269B · Gaithersburg, MDSep 17, 1979 · N9482F · Substantial damage NTSB IAD79DA079Accident · No injuriesClosedGrumman AA1C · Mt Airy, MDSep 13, 1979 · N31NA · Destroyed NTSB IAD79FA078Accident · No injuriesClosedCessna 320F · Chestertown, MDSep 9, 1979 · N30CR · Substantial damage NTSB IAD79FA072Accident · No injuriesClosedCessna 182RG · Annapolis, MDAug 30, 1979 · N6014C · Substantial damage NTSB IAD79FA069Accident · 2 fatalClosedCessna 310K · Cresaptown, MDAug 20, 1979 · N7060L · Destroyed NTSB IAD79DA071Accident · No injuriesClosedCessna 150 · Oakland, MDAug 20, 1979 · N5344Q · Destroyed NTSB IAD79FIG13Accident · No injuriesClosedCessna 150 · Westminster, MDAug 15, 1979 · N7930U · Destroyed NTSB IAD79FIG12Accident · No injuriesClosedCessna 172 · Gaithersburg, MDAug 10, 1979 · N5660E · Substantial damage NTSB IAD79FIG14Accident · No injuriesClosedErco 415-D · Crofton Mews, MDAug 7, 1979 · N99291 · Substantial damage NTSB IAD79FIG11Accident · Minor injuriesClosedPiper J5A · Taneytown, MDJul 31, 1979 · N33415 · Substantial damage NTSB IAD79FI610Accident · No injuriesClosedBellanca 7GCBC · Ocean City, MDJul 17, 1979 · N11718 · Substantial damage NTSB IAD79FIG09Accident · Serious injuriesClosedPiper PA-23 · Baltimore, MDJul 15, 1979 · N555WP · Destroyed NTSB IAD79FIG08Accident · No injuriesClosedCessna 177 · Westminster, MDJun 20, 1979 · N29400 · Substantial damage NTSB IAD79DIA13Accident · Minor injuriesClosedPiper J-3 · Naylor, MDJun 16, 1979 · N1500N · Substantial damage NTSB IAD79FIG07Accident · No injuriesClosedPiper PA-22 · College Park, MDJun 1, 1979 · N3618Z · Substantial damage NTSB IAD79FIG06Accident · Minor injuriesClosedPiper PA-28 · Oakland, MDMay 10, 1979 · N56112 · Substantial damage NTSB IAD79FIA12Accident · Minor injuriesClosedPiper PA-28 · Pomonkey, MDMay 6, 1979 · N6583W · Destroyed NTSB IAD79FIG05Accident · No injuriesClosedLake LA4200 · Dayton, MDApr 11, 1979 · N6158Y · Substantial damage NTSB IAD79FIA09Accident · No injuriesClosedCessna 170B · Clinton, MDMar 17, 1979 · N2735D · Substantial damage NTSB IAD79FA038Accident · 1 fatalClosedBellanca 8KCAB · Queenstown, MDMar 7, 1979 · N31278 · Destroyed NTSB IAD79FA033Accident · 3 fatalClosedPiper PA-31T · Baltimore, MDFeb 23, 1979 · N6123A · Destroyed NTSB IAD79IA031Incident · No injuriesClosedShorts SD3-30 · Baltimore, MDFeb 13, 1979 · N796HA · Minor damage