NTSB investigations, 1971, MD

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

Cases per year

19622026
NTSB investigations, 1971, MD per year, 1962–2026: 1,679 cases
19622
19631
196476
196581
196668
196772
196852
196969
197056
197139
197236
197335
197435
197532
197640
197741
197831
197929
198025
198122
198229
198334
198428
198530
198626
198732
198825
198933
199029
199121
199225
199316
199418
199524
199627
199725
199820
199924
200018
200119
200212
200312
200411
200511
200619
200713
200820
200913
201021
201123
201210
201315
201413
201520
201610
201714
201812
201917
202012
202110
202217
20238
20247
20255
20269

Latest cases

Query with SQL
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\") = 1971
    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.

NTSB NYC72DIG17Accident · No injuriesClosedPiper PA-28 · Montgomery, MDDec 31, 1971 · N3978K · Substantial damageNTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDDec 30, 1971 · N50534 · Substantial damageNTSB NYC72FIA10Accident · No injuriesClosedBeech A23-24 · Lexington Park, MDDec 20, 1971 · N5773V · DestroyedNTSB NYC72FIA09Accident · 2 fatalClosedLake LA-4A · Laplata, MDDec 12, 1971 · N1001L · DestroyedNTSB NYC72DIG15Accident · No injuriesClosedCessna 140 · Ocean City, MDDec 4, 1971 · N72619 · Substantial damageNTSB NYC72AN058Accident · 2 fatalClosedFairchild M-62A · Stevensville, MDOct 21, 1971 · N91022 · DestroyedNTSB NYC72FIG14Accident · Minor injuriesClosedGlobe GC-1B · Perry Hall, MDOct 16, 1971 · N80551 · Substantial damageNTSB NYC72AN041Accident · 3 fatalClosedCessna 337A · Boonsboro, MDSep 18, 1971 · N6333F · DestroyedNTSB NYC72DIA04Accident · No injuriesClosedChampion 7ECA · California, MDSep 11, 1971 · N5218X · Substantial damageNTSB NYC72FIG13Accident · Minor injuriesClosedMooney M20A · Mitchellville, MDSep 10, 1971 · N1082C · Substantial damageNTSB NYC72DIG12Accident · No injuriesClosedPiper PA-22 · Pasadena, MDSep 5, 1971 · N2240A · Substantial damageNTSB NYC72AN032Accident · 3 fatalClosedPiper PA-32 · Corriganville, MDSep 1, 1971 · N5225S · DestroyedNTSB NYC72AN030Accident · 3 fatalClosedPiper PA-28 · Accident, MDAug 27, 1971 · N6993W · DestroyedNTSB NYC72FIG10Accident · 1 fatalClosedDehavnd Can DHC-1B · Stevensville, MDAug 15, 1971 · N7749 · DestroyedNTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damageNTSB NYC72FIG06Accident · No injuriesClosedBell 47D-1 · Union Bridge, MDAug 12, 1971 · N4253A · DestroyedNTSB NYC72FIG09Accident · No injuriesClosedPiper PA-23 · Westminster, MDAug 9, 1971 · N2106P · Substantial damageNTSB NYC72FIG08Accident · No injuriesClosedPiper PA-28 · White Marsh, MDAug 7, 1971 · N5719U · Substantial damageNTSB NYC72DIG07Accident · No injuriesClosedCessna 182 · Cambridge, MDJul 21, 1971 · N3706D · Substantial damageNTSB IAD72AI003Accident · 1 fatalClosedPiper PA-28 · St.Michaels, MDJul 20, 1971 · N5298L · DestroyedNTSB IAD72FIG05Accident · Serious injuriesClosedMooney M20G · College Park, MDJul 16, 1971 · N3593X · DestroyedNTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDJul 5, 1971 · N4538U · Substantial damageNTSB IAD72FIG02Accident · Minor injuriesClosedHughes 269B · Bowie, MDJul 4, 1971 · N9424F · Substantial damageNTSB IAD72FIG01Accident · No injuriesClosedBell 206A · Rosedale, MDJul 3, 1971 · N2282W · Substantial damageNTSB IAD72FIG33Accident · No injuriesClosedPiper PA-22 · White Marsh, MDJun 30, 1971 · N7106B · Substantial damageNTSB IAD71FIG32Accident · No injuriesClosedBeech 35 · Golts, MDJun 20, 1971 · N3043V · Substantial damageNTSB IAD71DIA22Accident · No injuriesClosedCessna 170B · Cobb Island, MDJun 13, 1971 · N3483D · Substantial damageNTSB IAD71FIG31Accident · Serious injuriesClosedBeech B35 · Stevensville, MDMay 31, 1971 · N5142C · DestroyedNTSB MIA71IM101Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDMay 21, 1971 · N8962E · Minor damageNTSB IAD71FIA21Accident · Minor injuriesClosedCessna 150 · Lusby, MDMay 15, 1971 · N6426F · Substantial damageNTSB IAD71II052Incident · No injuriesClosedBeech B55 · Easton, MDMay 13, 1971 · N7956R · Minor damageNTSB IAD71AI050Accident · 1 fatalClosedCessna 172H · Hollywood, MDMay 8, 1971 · N2658L · DestroyedNTSB IAD71DIG30Accident · No injuriesClosedPiper PA-28 · Westminster, MDApr 27, 1971 · N6756W · Substantial damageNTSB IAD71FIG28Accident · Minor injuriesClosedCessna 172K · Fallston, MDApr 25, 1971 · N7028G · DestroyedNTSB IAD71FIG27Accident · Minor injuriesClosedPiper J3L-65 · Edgewater, MDApr 9, 1971 · N23Q · Substantial damageNTSB IAD71FIG29Accident · No injuriesClosedPiper PA-28 · White Marsh, MDApr 3, 1971 · N6692J · Substantial damageNTSB IAD71FIG26Accident · Serious injuriesClosedCessna 172 · College Park, MDMar 28, 1971 · N3704R · Substantial damageNTSB IAD71DIG25Accident · No injuriesClosedPiper J-3 · College Park, MDMar 6, 1971 · N70294 · Substantial damageNTSB IAD71II033Incident · No injuriesClosedBoeing 720 · Baltimore, MDJan 12, 1971 · N7207U · Minor damage