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 MIA77FA080Accident · 3 fatalClosedBeech 65-80 · Vancleave, MSAug 13, 1977 · N6DG · Destroyed NTSB MIA77FKQ29Accident · No injuriesClosedGrumman G-164B · Houston, MSAug 4, 1977 · N48628 · Substantial damage NTSB MIA77FKQ28Accident · No injuriesClosedCessna A188B · Myrte, MSAug 4, 1977 · N21705 · Substantial damage NTSB MIA77FKQ27Accident · Serious injuriesClosedCessna A188B · Tchula, MSAug 2, 1977 · N53296 · Destroyed NTSB MIA77FKQ26Accident · No injuriesClosedGrumman G-164B · Tchula, MSAug 2, 1977 · N63D · Substantial damage NTSB MIA77FA073Accident · 1 fatalClosedBellanca 7GCBC · Leland, MSAug 2, 1977 · N36379 · Destroyed NTSB MIA77FKQ24Accident · 1 fatalClosedPiper PA-18 · Louisville, MSJul 26, 1977 · N1358C · Destroyed NTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSJul 23, 1977 · N6543 · 2 aircraft · Destroyed NTSB MIA77FKQ23Accident · No injuriesClosedLake LA-4 · Tylertown, MSJul 23, 1977 · N1220L · Substantial damage NTSB MIA77FKQ22Accident · No injuriesClosedCessna A188 · Winterville, MSJul 14, 1977 · N21808 · Substantial damage NTSB MIA77FKQ21Accident · Serious injuriesClosedCessna 188B · Flora, MSJul 12, 1977 · N9143R · Destroyed NTSB MIA77FKQ18Accident · No injuriesClosedCessna 188 · Leland, MSJun 20, 1977 · N79581 · Substantial damage NTSB MIA77FKQ20Accident · Minor injuriesClosedCallair A9A · Holly Bluff, MSJun 17, 1977 · N3576G · Substantial damage NTSB MIA77KK019Accident · No injuriesClosedLuscombe 8A · Louisville, MSJun 14, 1977 · N71127 · Destroyed NTSB MIA77FKQ17Accident · No injuriesClosedCessna A188B · Vicksburg, MSJun 1, 1977 · N91229 · Destroyed NTSB NYC77FNE21Accident · No injuriesClosedSchweizer SGS126 · Sterling, MSMay 28, 1977 · N1106S · Substantial damage NTSB MIA77FKQ16Accident · No injuriesClosedCessna A188B · Lambert, MSMay 27, 1977 · N70389 · Destroyed NTSB MIA77FKQ15Accident · No injuriesClosedGrumman G-164B · Pugh City, MSMay 19, 1977 · N48646 · Destroyed NTSB MIA77FKQ13Accident · Serious injuriesClosedPiper J5A · Hattiesburg, MSMay 15, 1977 · N30947 · Destroyed NTSB MIA77FKQ14Accident · Serious injuriesClosedCessna A188B · Tutwiler, MSMay 13, 1977 · N21654 · Destroyed NTSB MIA77FLT03Accident · Minor injuriesClosedCessna 140 · Walls, MSMay 6, 1977 · N2301V · Destroyed NTSB MIA77FKQ12Accident · Serious injuriesClosedGrumman AA5 · Hattiesburg, MSApr 17, 1977 · N1371R · Destroyed NTSB MIA77DLT02Accident · No injuriesClosedCessna 188 · Holly Spring, MSApr 15, 1977 · N53307 · Substantial damage NTSB MIA77FKQ10Accident · Minor injuriesClosedCessna R172E · Newton, MSApr 8, 1977 · N103RL · Substantial damage NTSB MIA77FKQ07Accident · 1 fatalClosedBellanca 8GCBC · Edwards, MSApr 7, 1977 · N86981 · Destroyed NTSB MIA77DKQ11Accident · No injuriesClosedBeech E33 · Tutwiler, MSApr 5, 1977 · N8409N · Substantial damage NTSB MIA77FKQ09Accident · Minor injuriesClosedCessna 402 · Madison, MSMar 17, 1977 · N4530Q · Destroyed NTSB MIA77FKQ08Accident · No injuriesClosedPiper PA-28R · Petal, MSMar 9, 1977 · N1540X · Substantial damage NTSB MIA77FLT01Accident · Serious injuriesClosedDehavilland OHC-1 · Walls, MSJan 22, 1977 · N8DW · Substantial damage NTSB MIA77FKQ06Accident · Minor injuriesClosedAeronca 7AC · Madison, MSJan 22, 1977 · N1956E · Substantial damage NTSB MIA77FA023Accident · 1 fatalClosedCessna 172 · Wiggins, MSJan 3, 1977 · N12771 · Destroyed NTSB MIA77FKQ05Accident · Serious injuriesClosedGrum Amer AA-5B · Jackson, MSJan 2, 1977 · N74859 · Substantial damage NTSB MIA77FKQ04Accident · No injuriesClosedCessna 182 · Gluckstadt, MSDec 18, 1976 · N5814B · Substantial damage NTSB MIA77FKQ03Accident · Minor injuriesClosedPiper PA-23 · Natchez, MSNov 18, 1976 · N13903 · Destroyed NTSB MIA77FA006Accident · 2 fatalClosedLuscombe 8E · Batesville, MSNov 1, 1976 · N1666K · Destroyed NTSB MIA77FKQ02Accident · Serious injuriesClosedAero Comdr 600S2R · Swiftown, MSOct 4, 1976 · N4173X · Destroyed NTSB MIA76FKQ01Accident · Minor injuriesClosedCessna 188A · Carthage, MSOct 2, 1976 · N9987G · Destroyed NTSB MIA76FKQ47Accident · 2 fatalClosedPiper PA-18 · Flora, MSSep 14, 1976 · N4686Y · Destroyed NTSB MIA76DKQ46Accident · No injuriesClosedCessna A188A · Bruce, MSSep 9, 1976 · N1586M · Substantial damage NTSB MIA76FKQ48Accident · No injuriesClosedCessna 150L · Meridian, MSAug 29, 1976 · N6647G · Substantial damage NTSB MIA76FKQ45Accident · No injuriesClosedGrumman G-164A · Flora, MSAug 26, 1976 · N7225 · Substantial damage NTSB MIA76AM105Accident · 1 fatalClosedPiper PA-23 · Clarksdale, MSAug 23, 1976 · N4889P · Destroyed NTSB MIA76FKQ44Accident · No injuriesClosedCessna 188B · Batesville, MSAug 14, 1976 · N91752 · Destroyed NTSB MIA76FKQ43Accident · No injuriesClosedCessna 172M · Holly Bluff, MSAug 11, 1976 · N1602V · Substantial damage NTSB MIA76FKQ42Accident · No injuriesClosedCessna 188B · Picayune, MSAug 10, 1976 · N8979G · Substantial damage NTSB MIA76FKQ41Accident · No injuriesClosedGrumman G-164 · Minter City, MSJul 29, 1976 · N651Y · Substantial damage NTSB MIA76FKQ40Accident · No injuriesClosedCessna 188 · Arcola, MSJul 26, 1976 · N9964G · Substantial damage NTSB MIA76FKQ38Accident · Serious injuriesClosedCessna 188 · Louisville, MSJul 21, 1976 · N21823 · Substantial damage NTSB MIA76FKQ39|MIA76FK039Accident · No injuriesClosedCessna 188 · Shelby, MSJul 20, 1976 · N21862 · 2 aircraft · Substantial damage NTSB MIA76FKQ37Accident · No injuriesClosedCessna A188B · Hollandale, MSJul 9, 1976 · N6694G · Substantial damage