NTSB investigations, 1977, MD

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1977, 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\") = 1977
    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 IAD78DIG04Accident · No injuriesClosedCessna 182 · Hempstead, MDDec 23, 1977 · C-FUFE · Substantial damageNTSB IAD78FA019Accident · 2 fatalClosedVarga 2150A · Jessup, MDDec 5, 1977 · N4612V · DestroyedNTSB IAD78FIG03Accident · Minor injuriesClosedCessna 195B · Elkton, MDDec 4, 1977 · N4472C · Substantial damageNTSB IAD78FA011Accident · 2 fatalClosedPiper PA-32 · Emmitsburg, MDNov 7, 1977 · N3347W · DestroyedNTSB IAD78FIG02Accident · No injuriesClosedCessna 210 · Edgewater, MDNov 1, 1977 · N7429E · Substantial damageNTSB IAD78FIG01Accident · Minor injuriesClosedPiper PA28 · Baltimore, MDOct 10, 1977 · N5310T · DestroyedNTSB IAD77FIG36Accident · No injuriesClosedBeech 200 · Gaithersburg, MDSep 26, 1977 · N725MC · Substantial damageNTSB IAD77FIG35Accident · No injuriesClosedHughes 269B · Gaithersburg, MDSep 15, 1977 · N9568F · Substantial damageNTSB IAD77FA066Accident · Serious injuriesClosedPiper PA-28 · Clinton, MDSep 15, 1977 · N9879W · DestroyedNTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDAug 28, 1977 · N9110L · Substantial damageNTSB IAD77FIG34Accident · No injuriesClosedCessna 150L · Tryaskin, MDAug 21, 1977 · N10765 · Substantial damageNTSB IAD77FIG32Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDAug 14, 1977 · N8006C · Substantial damageNTSB IAD77FIG33Accident · No injuriesClosedPiper PA-22 · Mitchellville, MDAug 11, 1977 · N2544A · Substantial damageNTSB IAD77FA058Accident · 1 fatalClosedGrum Amer AA1-B · Unity, MDAug 11, 1977 · N9677L · DestroyedNTSB IAD77IA057Incident · No injuriesClosedBell 206L · Poolesville, MDAug 7, 1977 · N16664 · No damageNTSB IAD77FIG31Accident · No injuriesClosedBeech 23 · Essex, MDJul 27, 1977 · N824PJ · Substantial damageNTSB IAD77FIG28Accident · No injuriesClosedBeech 23 · Gaithersburg, MDJul 23, 1977 · N6VT · Substantial damageNTSB IAD77FIG26Accident · No injuriesClosedCessna 150 · Baltimore, MDJul 18, 1977 · N50823 · Substantial damageNTSB IAD77FIG27Accident · Minor injuriesClosedCessna 172C · Stevensville, MDJul 17, 1977 · N2029Y · Substantial damageNTSB IAD77FIG25Accident · No injuriesClosedBeech B24R · Carmichael, MDJul 15, 1977 · N2570W · Substantial damageNTSB IAD77FIG24Accident · Minor injuriesClosedCessna 150G · Aberdeen, MDJul 11, 1977 · N6310S · Substantial damageNTSB IAD77FIA20Accident · Minor injuriesClosedAeronca 7AC · Balalton, MDJul 7, 1977 · N85226 · Substantial damageNTSB IAD77FIG30Accident · No injuriesClosedRyan ST-A · Frederick, MDJul 1, 1977 · N17364 · Substantial damageNTSB IAD77FIG29Accident · No injuriesClosedChampion 7KCAB · Ocean City, MDJul 1, 1977 · N7532F · Substantial damageNTSB IAD77FIG22Accident · No injuriesClosedLake LA4 · Essex, MDJun 30, 1977 · N1236L · Substantial damageNTSB IAD77FIG21Accident · Minor injuriesClosedCessna 172 · College Park, MDJun 25, 1977 · N2477L · Substantial damageNTSB IAD77DIA19Accident · No injuriesClosedCessna 150A · California, MDJun 25, 1977 · N9852J · Substantial damageNTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDMay 31, 1977 · N20480 · DestroyedNTSB IAD77FIG20Accident · Minor injuriesClosedSchweizer 1-26 · Frostburg, MDMay 21, 1977 · N8668R · Substantial damageNTSB IAD77FIG19Accident · Minor injuriesClosedPiper PA22 · Laytonsville, MDMay 20, 1977 · N1612P · Substantial damageNTSB IAD77FIG18Accident · Serious injuriesClosedAero Cmdr 200D · Sussex, MDMay 15, 1977 · N5501M · Substantial damageNTSB IAD77FIG17Accident · No injuriesClosedGrum Amer AA1 · Darlington, MDMay 8, 1977 · N5748L · Substantial damageNTSB IAD77FIA13Accident · Serious injuriesClosedBeech B-35 · Hollywood, MDMay 8, 1977 · N8922A · DestroyedNTSB IAD77FIG16Accident · No injuriesClosedEnstrom F28A · Pikesville, MDApr 21, 1977 · N9566 · DestroyedNTSB IAD77IA037Incident · No injuriesClosedPiper PA-32R · Forest Hills, MDApr 20, 1977 · N4505X · Minor damageNTSB IAD77FIG15Accident · Minor injuriesClosedChampion 7ECA · Churchville, MDMar 27, 1977 · N11030 · Substantial damageNTSB IAD77DIA10Accident · Minor injuriesClosedPitts S1 · Clinton, MDMar 19, 1977 · N4111 · Substantial damageNTSB IAD77FIG13Accident · Serious injuriesClosedCessna 172 · Cumberland, MDMar 18, 1977 · N75632 · DestroyedNTSB IAD77FIG11Accident · Serious injuriesClosedBellanca 7ECA · Galena, MDFeb 19, 1977 · N57679 · Substantial damageNTSB IAD77FIG10Accident · No injuriesClosedHughes 269B · Gaithersburg, MDJan 23, 1977 · N9483F · Substantial damageNTSB IAD77FA017Accident · Serious injuriesClosedDouglas DC-8 · Baltimore, MDJan 16, 1977 · N904CL · Minor damage