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 DIA69F0019Accident · No injuriesClosedN.American SNJ4 · Frederick, MDJul 7, 1968 · N4140A · Substantial damage NTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDJul 5, 1968 · N9399J · Destroyed NTSB DIA69F0022Accident · Minor injuriesClosedPiper PA-12 · Ocean City, MDJun 28, 1968 · N7794H · Destroyed NTSB DIA69D0016Accident · No injuriesClosedPiper J-3 · Waldorf, MDJun 23, 1968 · N30589 · Substantial damage NTSB DIA69D0010Accident · No injuriesClosedCessna 150 · Solomons, MDJun 22, 1968 · N7874Z · Substantial damage NTSB DIA69F0007Accident · Minor injuriesClosedPiper PA-22 · Chestertown, MDJun 7, 1968 · N3637Z · Substantial damage NTSB DIA69F0006Accident · No injuriesClosedCessna 150 · Fallston, MDJun 6, 1968 · N23450 · Destroyed NTSB DIA69D0002Accident · No injuriesClosedCessna 182G · Lexington Park, MDMay 30, 1968 · N3170S · Substantial damage NTSB DIA68D0236Accident · Minor injuriesClosedCessna 172 · Sykesville, MDMay 30, 1968 · N7064A · Destroyed NTSB DIA68F0226Accident · Minor injuriesClosedPiper PA-17 · Edgewater, MDMay 18, 1968 · N4844H · Destroyed NTSB DIA68A0049Accident · 4 fatalClosedPiper PA-28 · Myersville, MDMay 15, 1968 · N9215W · Destroyed NTSB DIA68F0229Accident · No injuriesClosedCessna 195 · Gaithersburg, MDMay 12, 1968 · N1565D · Substantial damage NTSB DIA68F0195Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDApr 21, 1968 · N4030N · Substantial damage NTSB DIA68F0213Accident · Minor injuriesClosedPiper PA-22 · Rising Sun, MDApr 20, 1968 · N3611A · Substantial damage NTSB DIA68F0206Accident · Minor injuriesClosedCessna 172 · Queenstown, MDApr 14, 1968 · N6714A · Substantial damage NTSB DIA68F0199Accident · Minor injuriesClosedCessna 182 · Stevensville, MDApr 14, 1968 · N8911T · Substantial damage NTSB DIA68F0207Accident · No injuriesClosedPiper J5A · College Park, MDApr 13, 1968 · N38710 · Substantial damage NTSB DIA68A0040Accident · 2 fatalClosedCessna 150F · Churchville, MDMar 28, 1968 · N8120F · Destroyed NTSB DIA68F0192Accident · Minor injuriesClosedPiper PA-22 · Laurel, MDMar 27, 1968 · N3126Z · Substantial damage NTSB DIA68F0188Accident · No injuriesClosedN American P-51D · Frederick, MDMar 21, 1968 · N3751D · Destroyed NTSB DIA68A0039Accident · 2 fatalClosedHughes 300 · Marlow Heights, MDMar 21, 1968 · N9502F · Destroyed NTSB DIA68F0183Accident · No injuriesClosedErco 415-C · Gaithersburg, MDMar 15, 1968 · N2541H · Substantial damage NTSB DIA68F0176Accident · Minor injuriesClosedPiper PA-22 · Simpsonville, MDMar 9, 1968 · N1411A · Substantial damage NTSB DIA68F0179Accident · Minor injuriesClosedCessna 170B · Friendship Apt, MDMar 2, 1968 · N8055A · Destroyed NTSB DIA68F0168Accident · No injuriesClosedCessna 182 · Friendship Apt, MDFeb 17, 1968 · N8310S · Substantial damage NTSB DIA68F0163Accident · No injuriesClosedPiper PA-24 · Crisfield, MDFeb 6, 1968 · N7009P · Substantial damage NTSB DIA68D0146Accident · Serious injuriesClosedNavion A · Lusby, MDJan 21, 1968 · N91666 · No damage NTSB DIA68A0029Accident · No injuriesClosedFchld-Hillr FH1100 · Hagerstown, MDJan 12, 1968 · CF-WMG · Substantial damage NTSB DIA68I0028Incident · Minor injuriesClosedLockheed L-18 · Baltimore, MDJan 8, 1968 · N777W · Substantial damage NTSB DIA68D0133Accident · No injuriesClosedBeech D95A · Salisbury, MDDec 5, 1967 · N5609S · Substantial damage NTSB DIA68F0131Accident · No injuriesClosedPiper PA-22 · Odenton, MDNov 26, 1967 · N5974Z · Substantial damage NTSB DIA68D0126Accident · No injuriesClosedCessna 170 · Laurel, MDNov 18, 1967 · N2541V · Substantial damage NTSB DIA68A0020Accident · 3 fatalClosedPiper PA-18 · Conowingo, MDNov 18, 1967 · N3193Z · Destroyed NTSB DIA68D0119Accident · No injuriesClosedBeech D35 · College Park, MDNov 11, 1967 · N2109D · Substantial damage NTSB DIA68F0098Accident · No injuriesClosedCessna 182J · Clinton, MDOct 26, 1967 · N3512F · Substantial damage NTSB DIA68F0104Accident · No injuriesClosedPiper PA-28 · College Park, MDOct 25, 1967 · N6337W · Substantial damage NTSB DIA68D0116Accident · No injuriesClosedChampion 7KC · Lothian, MDOct 24, 1967 · N2574G · Substantial damage NTSB DIA68D0087Accident · No injuriesClosedPiper PA-28 · Laurel, MDOct 9, 1967 · N9611J · Substantial damage NTSB DIA68D0084Accident · No injuriesClosedWaco RNF · Huntington, MDSep 24, 1967 · N11206 · Substantial damage NTSB DIA68D0085Accident · No injuriesClosedN American P-51 · Frederick, MDSep 16, 1967 · N3751D · Substantial damage NTSB DIA68F0077Accident · Serious injuriesClosedPiper PA-28 · Federalsburg, MDSep 7, 1967 · N6515W · Substantial damage NTSB DIA68D0076Accident · No injuriesClosedPiper PA-24 · Mitchelville, MDSep 1, 1967 · N740W · Substantial damage NTSB DIA68D0071Accident · No injuriesClosedPiper PA-28 · Edgewater, MDAug 29, 1967 · N4156J · 2 aircraft · Substantial damage NTSB DIA68F0072Accident · No injuriesClosedMooney M20E · Friendship Int., MDAug 28, 1967 · N9348M · Substantial damage NTSB DIA68A0008Accident · 1 fatalClosedNavion NAV-A · Maugansville, MDAug 26, 1967 · N8792H · Destroyed NTSB DIA68A0005Accident · No injuriesClosedBeech E18S · Friendship, MDAug 20, 1967 · N39L · Substantial damage NTSB DIA68D0056Accident · No injuriesClosedBeech D18S · Baltimore, MDAug 14, 1967 · N3531B · Substantial damage NTSB DIA68F0059Accident · Minor injuriesClosedCessna 140 · Davidsonville, MDAug 11, 1967 · N76539 · Substantial damage NTSB DIA68F0061Accident · Minor injuriesClosedPiper PA-28 · Laurel, MDAug 9, 1967 · N9399J · Substantial damage NTSB DIA68D0040Accident · No injuriesClosedLuscombe 8E · Edgewater, MDJul 25, 1967 · N1311B · Substantial damage