Skip to content

NTSB investigations, 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.

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 NYC66D0147Accident · No injuriesClosedPiper PA-22 · Ft Meade, MDAug 7, 1965 · N5780Z · Substantial damage NTSB NYC66D0141Accident · No injuriesClosedBeechcraft 23 · Gaithersburg, MDAug 5, 1965 · N2335Q · Substantial damage NTSB NYC66A0018Accident · 2 fatalClosedPiper PA-23 · Union Bridge, MDAug 4, 1965 · N4778P · Destroyed NTSB NYC66A0016Accident · 4 fatalClosedCessna 172F · Newburg, MDJul 29, 1965 · N5469R · Destroyed NTSB NYC66A0014Accident · No injuriesClosedBell 47G2 · Hollywood, MDJul 27, 1965 · N6752D · Substantial damage NTSB NYC66D0140Accident · No injuriesClosedCessna 172 · Princess Anne, MDJul 26, 1965 · N6325E · Substantial damage NTSB NYC66F0148Accident · No injuriesClosedPiper PA-22 · Salisbury, MDJul 25, 1965 · N943A · Substantial damage NTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDJul 21, 1965 · N9863Y · Substantial damage NTSB NYC66F0060Accident · No injuriesClosedCessna 172 · Still Pond, MDJul 19, 1965 · N3670S · Substantial damage NTSB NYC66F0064Accident · Serious injuriesClosedPiper J3C · Baltimore, MDJul 17, 1965 · N70429 · Substantial damage NTSB NYC66A0009Accident · No injuriesClosedBrantly B-2 · Suitland, MDJul 12, 1965 · N2277U · Substantial damage NTSB NYC66A0003Accident · 1 fatalClosedHughes 269B · Waldorf, MDJul 8, 1965 · N942OF · Destroyed NTSB NYC66F0070Accident · No injuriesClosedPiper PA-22 · Cumberland, MDJul 3, 1965 · N8816D · Substantial damage NTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDJun 29, 1965 · N6193T · Substantial damage NTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDJun 27, 1965 · N72455 · Destroyed NTSB NYC66F0097Accident · No injuriesClosedMoonraker 100 · Gaithersburg, MDJun 22, 1965 · N8669E · Substantial damage NTSB NYC66F0071Accident · No injuriesClosedNavion L-17A · Potomac, MDJun 17, 1965 · N999S · Substantial damage NTSB NYC66F0003Accident · Serious injuriesClosedLuscombe 8A · Mitchellville, MDJun 11, 1965 · N77Q · Substantial damage NTSB NYC65A0147Accident · No injuriesClosedBell 47G2 · Laurel, MDJun 11, 1965 · N6758D · Substantial damage NTSB NYC66F0066Accident · No injuriesClosedBeechcraft G35 · Church Hill, MDJun 9, 1965 · N4204D · Substantial damage NTSB NYC66F0011Accident · No injuriesClosedAero CDR 560A · Baltimore, MDJun 6, 1965 · N2785B · Minor damage NTSB NYC66D0031Accident · No injuriesClosedPiper PA-24 · Snow Hill, MDJun 6, 1965 · N7982P · Substantial damage NTSB NYC65A0141Accident · 4 fatalClosedPiper PA-28 · Granite, MDMay 26, 1965 · N6356W · 2 aircraft · Destroyed NTSB NYC65F0226Accident · No injuriesClosedPiper PA-12 · Baltimore, MDMay 23, 1965 · N4454M · Substantial damage NTSB NYC66F0037Accident · Minor injuriesClosedPiper PA-28 · Bainbridge, MDMay 18, 1965 · N5697W · Substantial damage NTSB NYC66F0002Accident · No injuriesClosedCessna 170A · Gaithersburg, MDMay 15, 1965 · N9792A · Substantial damage NTSB NYC65A0138Accident · 2 fatalClosedWaco UPF-7 · Ocean City, MDMay 9, 1965 · N39722 · Destroyed NTSB NYC65F0203Accident · Serious injuriesClosedTaylorcraft BC12D · Parkville, MDMay 6, 1965 · N96828 · Substantial damage NTSB NYC66F0004Accident · No injuriesClosedCuster CCW-5 · Hagerstown, MDApr 29, 1965 · N5855V · Substantial damage NTSB NYC65F0150Accident · No injuriesClosedBeechcraft 65-80 · Frederick, MDApr 20, 1965 · N4444Q · Substantial damage NTSB NYC65F0134Accident · No injuriesClosedPiper PA-22 · Friendly, MDApr 14, 1965 · N5267Z · Substantial damage NTSB NYC65F0131Accident · No injuriesClosedCessna 172A · Westminster, MDApr 12, 1965 · N9787T · Substantial damage NTSB NYC65F0141Accident · No injuriesClosedCessna 210B · Gaithersburg, MDApr 8, 1965 · N9624X · Substantial damage NTSB NYC65F0133Accident · No injuriesClosedCessna 172 · Gaithersburg, MDApr 4, 1965 · N7883X · Substantial damage NTSB NYC65F0088Accident · No injuriesClosedPiper PA-22 · Edgewater, MDApr 1, 1965 · N6062D · Substantial damage NTSB NYC65F0117Accident · Serious injuriesClosedCessna 150 · Denton, MDMar 28, 1965 · N578U · Destroyed NTSB NYC66D0111Accident · No injuriesClosedChampion 7FC · Laytonsville, MDMar 27, 1965 · N9014B · Substantial damage NTSB NYC65F0094Accident · No injuriesClosedPiper PA-17 · Laytonsville, MDMar 21, 1965 · N4584H · Substantial damage NTSB NYC65F0071Accident · No injuriesClosedCessna 120 · Sykesville, MDMar 14, 1965 · N4124N · Substantial damage NTSB NYC65F0066Accident · No injuriesClosedBeechcraft 33-35 · Gaithersburg, MDMar 6, 1965 · N659V · Substantial damage NTSB NYC65F0076Accident · Serious injuriesClosedPiper PA-18 · Essex, MDMar 4, 1965 · N253T · Destroyed NTSB NYC65F0072Accident · No injuriesClosedStinson 108-3 · Clinton, MDMar 1, 1965 · N6756M · Minor damage NTSB NYC65F0051Accident · No injuriesClosedCessna 182 · North East, MDFeb 16, 1965 · N5873B · Substantial damage NTSB NYC65A0107Incident · No injuriesClosedBrantly B2 · Clinton, MDFeb 12, 1965 · N5973X · Substantial damage NTSB UNK65X1396Accident · Minor injuriesClosedPiper PA24 · Sykesville, MDFeb 5, 1965 · N6377P · Substantial damage NTSB NYC65F0034Accident · Minor injuriesClosedCessna 172 · Mitchellville, MDJan 30, 1965 · N5656T · Destroyed NTSB UNK65X1360Accident · No injuriesClosedCessna 182 · Clinton, MDJan 27, 1965 · N1957X · Substantial damage NTSB UNK65X1222Accident · No injuriesClosedPiper J3 · White Marsh, MDJan 3, 1965 · N23327 · Substantial damage NTSB NYC65F0012Accident · No injuriesClosedBeechraft D18S · Frederick, MDJan 1, 1965 · N411U · Substantial damage NTSB NYC65A0093Accident · Minor injuriesClosedBrantly B2B · Oxon Hill, MDJan 1, 1965 · N2191U · Destroyed