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 MIA78FKQ27Accident · No injuriesClosedAyres S2R · Rome, MSJul 31, 1978 · N4247X · Destroyed NTSB MIA78FKQ26Accident · No injuriesClosedGrumman G-164 · Tutwiler, MSJul 28, 1978 · N5623X · Destroyed NTSB MIA78FKQ25Accident · Minor injuriesClosedWeatherly 201B · Drew, MSJul 26, 1978 · N2938W · Substantial damage NTSB MIA78DKQ24Accident · No injuriesClosedCessna A188B · Choctaw, MSJul 21, 1978 · N4866Q · Substantial damage NTSB MIA78DKQ23Accident · Minor injuriesClosedCessna 188B · Doddsville, MSJul 19, 1978 · N4945Q · Destroyed NTSB MIA78DKQ22Accident · No injuriesClosedPiper PA-25 · Valley Park, MSJul 17, 1978 · N8643L · Substantial damage NTSB MIA78FKQ21Accident · No injuriesClosedPiper PA-36 · Leland, MSJul 16, 1978 · N57587 · Destroyed NTSB MIA78FKQ20Accident · No injuriesClosedBell 47G3B · Fayette, MSJul 11, 1978 · N73208 · Substantial damage NTSB MIA78KKQ19Accident · No injuriesClosedGrumman G-164A · Sunflower, MSJul 8, 1978 · N8959H · Substantial damage NTSB MIA78FKQ18Accident · No injuriesClosedCessna 152 · Greenwood, MSJun 29, 1978 · N67309 · Substantial damage NTSB MIA78FKQ17Accident · No injuriesClosedPiper PA-25 · Schlater, MSJun 29, 1978 · N7141Z · No damage NTSB MIA78FKQ15Accident · Minor injuriesClosedCessna A188B · Philipp, MSMay 31, 1978 · N4993R · Destroyed NTSB MIA78FKQ12Accident · No injuriesClosedBell 47G3B · Red Lick, MSMay 28, 1978 · N73249 · Destroyed NTSB MIA78FKQ14Accident · Minor injuriesClosedBell 47G · Fayette, MSMay 26, 1978 · N73965 · Destroyed NTSB MIA78FKQ11Accident · No injuriesClosedWaco UPF-7 · Meridian, MSMay 16, 1978 · N39737 · Substantial damage NTSB MIA78FKQ10Accident · Serious injuriesClosedPiper PA-34 · Laurel, MSMay 6, 1978 · N47488 · Destroyed NTSB MIA78FKQ09Accident · No injuriesClosedAero Comdr S2R · Stringtown, MSApr 28, 1978 · N8931Q · Substantial damage NTSB MIA78FA069Accident · 1 fatalClosedCessna 172 · Benoit, MSApr 22, 1978 · N2304U · Destroyed NTSB MIA78FKQ08Accident · Serious injuriesClosedPiper PA-28 · Nachez, MSApr 16, 1978 · N4350X · Substantial damage NTSB MIA78FKQ07Accident · Serious injuriesClosedCessna 150L · Hallandale, MSApr 14, 1978 · N1531Q · Destroyed NTSB MIA78FA065Accident · 2 fatalClosedBellanca 17-30A · Gulfport, MSApr 11, 1978 · N39817 · Destroyed NTSB MIA78FA050Accident · 2 fatalClosedCessna 310I · Laurel, MSMar 7, 1978 · N8114M · Destroyed NTSB MIA78DKQ04Accident · No injuriesClosedCessna 188 · Calhoun City, MSFeb 24, 1978 · N70214 · Substantial damage NTSB MIA78FKQ05Accident · No injuriesClosedN.American P-51 · Ellisville, MSFeb 15, 1978 · N117E · Substantial damage NTSB MIA78FA031Accident · 5 fatalClosedBeech B-90 · Yazoo City, MSJan 10, 1978 · N388MC · Destroyed NTSB MIA78FA030Accident · 4 fatalClosedBeech B-58P · Tylertown, MSJan 8, 1978 · N7264R · Destroyed NTSB MIA78FKQ04Accident · Minor injuriesClosedCessna 172 · Natchez, MSDec 24, 1977 · N1097U · Substantial damage NTSB MIA78FLT01Accident · No injuriesClosedPiper PA-28 · Arkabutla, MSNov 11, 1977 · N15361 · Substantial damage NTSB MIA78FKQ03Accident · 1 fatalClosedThrush S2R · Poplarville, MSOct 27, 1977 · N8921Q · Destroyed NTSB DCA78AA001Accident · 6 fatalClosedConvair 240 · Gillsburg, MSOct 20, 1977 · N55VM · Destroyed NTSB MIA78DKQ02Accident · No injuriesClosedCessna 188 · Mccomb, MSOct 18, 1977 · N8440G · Substantial damage NTSB MIA77KKQ01Accident · No injuriesClosedGrumman G-164A · Flora, MSOct 7, 1977 · N66020 · Substantial damage NTSB MIA77FA091Accident · 2 fatalClosedAeronca 7DC · Cleveland, MSSep 25, 1977 · N82685 · Destroyed NTSB MIA77FA090Accident · 1 fatalClosedCessna 150 · Water Valley, MSSep 24, 1977 · N6677G · Destroyed NTSB MIA77FA087Accident · 2 fatalClosedPiper PA-28 · Jackson, MSSep 12, 1977 · N98039 · Destroyed NTSB MIA77DKQ36Accident · No injuriesClosedCessna 188B · Sunflower, MSSep 12, 1977 · N731DH · Destroyed NTSB MIA77FKQ42Accident · Minor injuriesClosedCessna A188B · Morton, MSSep 11, 1977 · N21756 · Destroyed NTSB MIA77FKQ40Accident · Minor injuriesClosedPiper PA-22 · Picayune, MSAug 26, 1977 · N4755A · Substantial damage NTSB MIA77PKQ38Accident · No injuriesClosedCessna A188B · Rolling Fork, MSAug 25, 1977 · N91262 · Substantial damage NTSB MIA77FKQ39Accident · 1 fatalClosedCessna A188B · Winona, MSAug 25, 1977 · N79462 · Substantial damage NTSB MIA77FKQ37Accident · No injuriesClosedCessna A188B · Louisville, MSAug 24, 1977 · N5704G · Substantial damage NTSB MIA77FKQ35Accident · Serious injuriesClosedBell MK5-B · Lambert, MSAug 23, 1977 · N4227A · Substantial damage NTSB MIA77FLT05Accident · No injuriesClosedAero Comdr S-2R · Hernando, MSAug 21, 1977 · N5624X · Destroyed NTSB MIA77FKQ33Accident · No injuriesClosedPiper PA-28 · Natchez, MSAug 21, 1977 · N4504X · Substantial damage NTSB MIA77FA082Accident · 2 fatalClosedChampion 7EC · Yazoo City, MSAug 21, 1977 · N9003B · Destroyed NTSB MIA77FKQ32Accident · Serious injuriesClosedAero Comdr 100-18 · Jackson, MSAug 20, 1977 · N4036X · Substantial damage NTSB MIA77DKQ34Accident · No injuriesClosedCessna 188B · Grace, MSAug 19, 1977 · N70124 · Substantial damage NTSB MIA77FKQ31Accident · No injuriesClosedGrumman G164A · Flora, MSAug 18, 1977 · N48426 · Substantial damage NTSB MIA77FKQ25Accident · Serious injuriesClosedCessna A188B · Canton, MSAug 16, 1977 · N9139G · Destroyed NTSB MIA77FK030Accident · No injuriesClosedStinson 108-3 · Quitman, MSAug 14, 1977 · N6509M · Substantial damage