Skip to content

NTSB investigations, MD

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, newest first

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 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 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 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 UNK64X1679Accident · No injuriesClosedPiper PA22 · Baltimore, MDMay 9, 1964 · N3315B · Substantial damage NTSB UNK64X1659Accident · No injuriesClosedPiper PA24 · Baltimore, MDMay 7, 1964 · N5001P · Substantial damage NTSB UNK64X1413Accident · Minor injuriesClosedPiper J3 · Cumberland, MDApr 22, 1964 · N33232 · Substantial damage NTSB UNK64X1368Accident · Minor injuriesClosedErcoupe 415CD · Friendly, MDApr 18, 1964 · N94755 · Destroyed NTSB UNK64X1266Accident · No injuriesClosedBay Avia SUPER5 · Frederick, MDApr 11, 1964 · N549B · Destroyed NTSB UNK64X1231Accident · No injuriesClosedCessna 172 · Charles Co, MDApr 8, 1964 · CF0Y0 · Substantial damage NTSB UNK64X1169Accident · No injuriesClosedBeechcraft 23 · Chestertown, MDApr 4, 1964 · N2396J · Substantial damage NTSB UNK64X1159Accident · No injuriesClosedLuscombe 8A · Gaithersburg, MDApr 4, 1964 · N1127B · Substantial damage NTSB UNK64X1086Accident · No injuriesClosedMooney M20 · Cumberland, MDMar 28, 1964 · CFJCZ · Substantial damage NTSB UNK64X1077Accident · No injuriesClosedPiper PA28 · Edgewater, MDMar 28, 1964 · N5616W · Substantial damage NTSB UNK64X1069Accident · No injuriesClosedPiper J3 · Elkton, MDMar 28, 1964 · N98195 · Substantial damage NTSB UNK64X1056Accident · No injuriesClosedPiper PA28 · Westminister, MDMar 27, 1964 · N5334W · Substantial damage NTSB UNK64X1017Accident · No injuriesClosedPiper PA24 · Patuxent Nas, MDMar 22, 1964 · N5905P · Substantial damage NTSB UNK64X1005Accident · Minor injuriesClosedCessna 172 · Middletown, MDMar 21, 1964 · N3998S · Destroyed NTSB UNK64X0916Accident · No injuriesClosedBeechcraft 23 · Piney Point, MDMar 14, 1964 · N8709M · Substantial damage NTSB UNK64X0761Accident · No injuriesClosedPiper PA22 · Newburg, MDFeb 29, 1964 · N5680Z · Substantial damage NTSB UNK64X0699Accident · No injuriesClosedBeechcraft Superv · Mitchellville, MDFeb 26, 1964 · N1T · Substantial damage NTSB UNK64X0685Accident · No injuriesClosedBeechcraft B35 · Friendly, MDFeb 24, 1964 · N7973D · Substantial damage NTSB UNK64X0649Accident · No injuriesClosedCessna 120 · Frederick, MDFeb 22, 1964 · N90004 · Substantial damage NTSB UNK64X0563Accident · No injuriesClosedChampion 7FC · Westminister, MDFeb 14, 1964 · N7565E · Substantial damage NTSB UNK64X0521Accident · No injuriesClosedPiper PA22 · Laurel, MDFeb 9, 1964 · N5405Z · Substantial damage NTSB UNK64X0491Accident · No injuriesClosedCessna 150 · Park Hall, MDFeb 8, 1964 · N7009X · Destroyed NTSB UNK64X0436Accident · No injuriesClosedCessna 182 · Dawsonville, MDFeb 2, 1964 · N5476B · Substantial damage NTSB UNK64X0369Accident · Minor injuriesClosedPiper PA22 · Westminister, MDJan 26, 1964 · N5438Z · Substantial damage NTSB UNK64X0368Accident · No injuriesClosedPiper PA22 · Frederick, MDJan 26, 1964 · N5413Z · Substantial damage NTSB UNK64X0363Accident · No injuriesClosedPiper PA24 · Baltimore, MDJan 26, 1964 · N7808P · Substantial damage NTSB UNK64X0332Accident · No injuriesClosedAeronca 7AC · Westminister, MDJan 23, 1964 · N1030E · Substantial damage NTSB DCA64A0003Accident · 81 fatalClosedBoeing 707 · Elkton, MDDec 8, 1963 · N709PA · Destroyed NTSB NYC62A0127Accident · 17 fatalClosedVickers 745D · Ellicott City, MDNov 23, 1962 · N7430 · Destroyed NTSB NYC62A0103Accident · No injuriesClosedMartin 404 · Baltimore, MDOct 3, 1962 · N40423 · Minor damage