Skip to content

NTSB investigations, MS

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 UNK64X4032Accident · No injuriesClosedBoeing B75N1 · Belizoni, MSSep 18, 1964 · N10571 · Substantial damage NTSB UNK64X3881Accident · Minor injuriesClosedPiper PA25 · Avalon, MSSep 9, 1964 · N6781Z · Substantial damage NTSB UNK64X3877Accident · No injuriesClosedBell 47G4 · Canton, MSSep 8, 1964 · N3082G · Substantial damage NTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSSep 8, 1964 · N7991B · Substantial damage NTSB UNK64X3821Accident · Minor injuriesClosedPiper PA25 · Lambert, MSSep 6, 1964 · N6842Z · Destroyed NTSB UNK64X3795Accident · No injuriesClosedPiper PA30 · Wiggins, MSSep 5, 1964 · N7299Y · Substantial damage NTSB UNK64X3782Accident · Minor injuriesClosedCessna 150 · Madison, MSSep 5, 1964 · N7960Z · Substantial damage NTSB UNK64X3768Accident · No injuriesClosedBeechcraft G35 · Fayette, MSSep 4, 1964 · N4241D · Substantial damage NTSB UNK64X3757Accident · Minor injuriesClosedPiper PA18A · Midnight, MSSep 3, 1964 · N8992D · Destroyed NTSB UNK64X3716Accident · 1 fatalClosedPiper PA-18A · Greenwood, MSSep 1, 1964 · N8784D · Substantial damage NTSB UNK64X3673Accident · No injuriesClosedPiper PA28 · Laurel, MSAug 29, 1964 · N5357W · Substantial damage NTSB UNK64X3654Accident · Serious injuriesClosedBoeing B75N1 · Nitta Yuma, MSAug 28, 1964 · N50737 · Substantial damage NTSB UNK64X3592Accident · 1 fatalClosedPiper PA18A · Yazoo, MSAug 25, 1964 · N3887P · Destroyed NTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSAug 15, 1964 · N7022X · Destroyed NTSB UNK64X3212Accident · No injuriesClosedBoeing A75 · Yazoo City, MSAug 4, 1964 · N52532 · Destroyed NTSB UNK64X3100Accident · No injuriesClosedLuscombe 8E · Amory, MSJul 29, 1964 · N1941K · Substantial damage NTSB UNK64X3055Accident · Serious injuriesClosedSwift GC1B · Meridian Colo, MSJul 26, 1964 · N2346B · Destroyed NTSB UNK64X3013Accident · Serious injuriesClosedBoeing A75 · Inverness, MSJul 24, 1964 · N66519 · Destroyed NTSB UNK64X2911Accident · No injuriesClosedMooney MK20C · Bay Spings, MSJul 19, 1964 · N6888U · Substantial damage NTSB UNK64X2873Accident · No injuriesClosedBoeing A75 · Webb, MSJul 17, 1964 · N51420 · Substantial damage NTSB UNK64X2706Accident · Serious injuriesClosedCntl Copter G47 · Glen Allan, MSJul 7, 1964 · N73871 · Substantial damage NTSB UNK64X2673Accident · 1 fatalClosedCessna 172 · Gulfport, MSJul 5, 1964 · N7430X · Destroyed NTSB UNK64X2389Accident · Minor injuriesClosedCallair A9 · Vance, MSJun 20, 1964 · N3560G · Substantial damage NTSB UNK64X2239Accident · No injuriesClosedBoeing A75N1 · Minter City, MSJun 12, 1964 · N1656M · Substantial damage NTSB UNK64X2146Accident · No injuriesClosedSmith DSA1 · Madison, MSJun 6, 1964 · N1711 · Minor damage NTSB UNK64X2102Accident · No injuriesClosedCessna 172E · Canton, MSJun 4, 1964 · N3805S · Substantial damage NTSB UNK64X2090Accident · No injuriesClosedRiviera FN333 · Brookhaven, MSJun 3, 1964 · N623 · Substantial damage NTSB UNK64X2073Accident · No injuriesClosedAeronca 7AC · Mantee, MSJun 2, 1964 · N3600E · Substantial damage NTSB UNK64X2062Accident · Minor injuriesClosedPiper PA18 · New Albany, MSJun 1, 1964 · N8753C · Substantial damage NTSB UNK64X1858Accident · No injuriesClosedPiper PA22 · Belzoni, MSMay 20, 1964 · N5834Z · Substantial damage NTSB UNK64X1507Accident · No injuriesClosedCessna 172 · Picayune, MSApr 29, 1964 · N3980S · Substantial damage NTSB UNK64X1446Accident · No injuriesClosedCessna 182B · Horn Lake, MSApr 25, 1964 · N2286G · Substantial damage NTSB UNK64X1359Accident · No injuriesClosedCessna 120 · Macon, MSApr 18, 1964 · N89901 · Substantial damage NTSB UNK64X1256Accident · No injuriesClosedPiper PA28 · Hattiesburg, MSApr 11, 1964 · N5043W · Substantial damage NTSB UNK64X1221Accident · No injuriesClosedBeechcraft E18S · Columbia, MSApr 8, 1964 · N153J · Substantial damage NTSB UNK64X0799Accident · No injuriesClosedDouglas DC-3 · Tupelo, MSMar 4, 1964 · N62S · Substantial damage NTSB UNK64X0681Accident · 2 fatalClosedPiper J3 · Greenville, MSFeb 23, 1964 · N2069M · Destroyed NTSB UNK64X0616Accident · No injuriesClosedBeechcraft E35 · Picayune, MSFeb 19, 1964 · N3550B · Substantial damage NTSB UNK64X0544Accident · No injuriesClosedCessna 180 · Edwards, MSFeb 12, 1964 · N970T · Substantial damage NTSB UNK64X0421Accident · No injuriesClosedCessna T50 · Gloster, MSFeb 1, 1964 · N55028 · Substantial damage NTSB UNK64X0347Accident · Minor injuriesClosedPiper PA22 · Horn Lake, MSJan 25, 1964 · N5119Z · Substantial damage NTSB UNK64X0115Accident · No injuriesClosedBellanca 1419 · Holly Spring, MSJan 2, 1964 · N6577N · Substantial damage