Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDDec 14, 1972 · N6434G · Substantial damage NTSB NYC73FIG18Accident · Minor injuriesClosedAero Comdr 112 · Stevensville, MDNov 18, 1972 · N1014J · Substantial damage NTSB NYC73ANO67Accident · 2 fatalClosedSwift GC-1B · Salisbury, MDNov 12, 1972 · N80658 · Destroyed NTSB NYC73AN056Accident · 2 fatalClosedBell 206A · Graysonville, MDOct 28, 1972 · N4069G · Destroyed NTSB NYC73F1A07Accident · No injuriesClosedCessna 150 · Clinton, MDOct 22, 1972 · N5354Q · Substantial damage NTSB NYC73DIA06Accident · No injuriesClosedPiper PA-18 · Lothian, MDSep 26, 1972 · N236T · Substantial damage NTSB NYC73FIG16Accident · Serious injuriesClosedCessna 182 · Williamsport, MDSep 16, 1972 · N6472A · Destroyed NTSB NYC73FIG14Accident · Minor injuriesClosedCessna 172 · Sharpsburg, MDSep 15, 1972 · N6923A · Substantial damage NTSB NYC73FIG15Accident · No injuriesClosedLake LA-4 · Rockville, MDSep 14, 1972 · N39375 · Substantial damage NTSB NYC73FIG13Accident · No injuriesClosedPiper PA-22 · White Marsh, MDSep 10, 1972 · N5612Z · Substantial damage NTSB NYC73FIG12Accident · Serious injuriesClosedBoeing A75 · Vienna, MDSep 6, 1972 · N55432 · Substantial damage NTSB NYC73FIG11Accident · Minor injuriesClosedCessna 150G · College Park, MDSep 1, 1972 · N2631J · Destroyed NTSB NYC73FIG10Accident · Minor injuriesClosedPiper PA-28 · White Marsh, MDAug 20, 1972 · N5719U · Substantial damage NTSB NYC73FIG09Accident · Minor injuriesClosedPiper J-2 · Pasadena, MDJul 25, 1972 · N19511 · Destroyed NTSB NYC73FIG07Accident · No injuriesClosedBeech A45 · Keymar, MDJul 23, 1972 · N12257 · Substantial damage NTSB NYC73FIG06Accident · Minor injuriesClosedBeech A23-19 · Edgewater, MDJul 16, 1972 · N4764J · Destroyed NTSB NYC73FIG08Accident · No injuriesClosedCessna 150K · Sparrows Point, MDJul 15, 1972 · N6442G · Substantial damage NTSB NYC73FIG05Accident · Serious injuriesClosedChampion 7GCAA · Ocean City, MDJul 12, 1972 · N5145T · Substantial damage NTSB NYC73FIG03Accident · Serious injuriesClosedCessna 177 · College Park, MDJul 9, 1972 · N30027 · Destroyed NTSB NYC73DIG02Accident · No injuriesClosedPiper PA-28 · Churchville, MDJul 4, 1972 · N8941J · Substantial damage NTSB NYC73FIG01Accident · No injuriesClosedCessna 180 · Ridgely, MDJul 2, 1972 · N1717C · Substantial damage NTSB NYC72AN168Accident · No injuriesClosedPiper PA-32 · Catonsville, MDJun 30, 1972 · N8900N · Substantial damage NTSB NYC72FIG27Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 25, 1972 · N5439Q · Substantial damage NTSB NYC72FIG26Accident · Serious injuriesClosedPiper PA-32 · Oakland, MDMay 25, 1972 · N3930W · Substantial damage NTSB NYC72FIG23Accident · No injuriesClosedMaule M4220C · Keedysville, MDMay 17, 1972 · N2034U · Substantial damage NTSB NYC72FIG21Accident · No injuriesClosedCessna 182 · Gaithersburg, MDApr 23, 1972 · N3046F · Substantial damage NTSB NYC72FIG22Accident · No injuriesClosedCessna 150 · College Park, MDApr 21, 1972 · N2903S · Substantial damage NTSB NYC72AN119Accident · 1 fatalClosedPiper PA-28 · Laytonsville, MDMar 29, 1972 · N4353T · Destroyed NTSB NYC72AN115Accident · 1 fatalClosedCessna 150L · Stevensville, MDMar 18, 1972 · N1670Q · Destroyed NTSB NYC72IN112Incident · No injuriesClosedBeech 99 · Friendship Int, MDMar 16, 1972 · N296HA · No damage NTSB NYC72FIG20Accident · No injuriesClosedCessna 150 · Laurel, MDMar 12, 1972 · N6413G · Substantial damage NTSB NYC72AN107Accident · 2 fatalClosedPiper J-3 · College Park, MDMar 5, 1972 · N1399V · Destroyed NTSB NYC72FIG18Accident · No injuriesClosedCessna 172K · Westminster, MDFeb 27, 1972 · N7213G · Substantial damage NTSB NYC72AN088Accident · 2 fatalClosedCessna 172D · Perryville, MDJan 9, 1972 · N2551Y · Destroyed NTSB NYC72AN087Accident · 1 fatalClosedPiper PA-30 · Hanover, MDJan 4, 1972 · N8821Y · Destroyed NTSB NYC72FIA13Accident · No injuriesClosedBellanca 14-19 · Friendly, MDJan 1, 1972 · N522A · Substantial damage