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 MIA79DKQ19Accident · Minor injuriesClosedGrumman G-164A · Minter City, MSJul 26, 1979 · N5258 · Destroyed NTSB MIA79DKQ18Accident · Serious injuriesClosedNavion A · Crosby, MSJul 20, 1979 · N8877H · Destroyed NTSB MIA79DKQ17Accident · Minor injuriesClosedBellanca 7KCAB · Crowder, MSJul 14, 1979 · N7563F · Substantial damage NTSB MIA79FKQ16Accident · No injuriesClosedGrumman G-164A · Batesville, MSJul 13, 1979 · N8881H · Substantial damage NTSB MIA79DKQ15Accident · No injuriesClosedTomcat MK-5A · Lambert, MSJul 10, 1979 · N9099T · Substantial damage NTSB MIA79FKQ14Accident · 1 fatalClosedCessna A188B · Lyman, MSJul 7, 1979 · N4910R · Destroyed NTSB MIA79FKQ13Accident · Serious injuriesClosedCessna 170A · Raymond, MSJun 24, 1979 · N5420C · Substantial damage NTSB MIA79FLT06Accident · 1 fatalClosedPitts S1-C · Southaven, MSJun 17, 1979 · N20JH · Destroyed NTSB MIA79FA097Accident · 2 fatalClosedCessna 150L · Meridian, MSJun 16, 1979 · N19192 · Destroyed NTSB MIA79FKQ12Accident · No injuriesClosedCessna 188 · Bentonia, MSJun 8, 1979 · N731VY · Substantial damage NTSB MIA79FKQ11Accident · No injuriesClosedBell 47D · Parchman, MSJun 8, 1979 · N4227A · Substantial damage NTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSJun 5, 1979 · N9560D · Destroyed NTSB MIA79FKQ04Accident · No injuriesClosedCessna 182 · Greenville, MSMay 25, 1979 · N182CD · Destroyed NTSB MIA79FA087Accident · 2 fatalClosedCessna 152 · Greenville, MSMay 21, 1979 · N25356 · Destroyed NTSB MIA79DKQ10Accident · Minor injuriesClosedHiller UH12D · Drew, MSMay 1, 1979 · N48313 · Substantial damage NTSB MIA79DLT05Accident · Minor injuriesClosedEntwicklung C · Southaven, MSApr 28, 1979 · N11NE · Destroyed NTSB MIA79FKQ09Accident · Minor injuriesClosedPiper PA-22 · Newton, MSApr 19, 1979 · N4805A · Destroyed NTSB MIA79FKQ07Accident · Serious injuriesClosedGrumman G164A · Lucedale, MSApr 18, 1979 · N4573 · Destroyed NTSB MIA79FA073Accident · 1 fatalClosedPiper PA-30 · Rich, MSApr 18, 1979 · N8758Y · Destroyed NTSB MIA79FKQ06Accident · No injuriesClosedCessna 170A · Tupelo, MSApr 7, 1979 · N1256D · Substantial damage NTSB MIA79DKQ05Accident · No injuriesClosedCessna 182 · Tylertown, MSApr 2, 1979 · N21LW · Substantial damage NTSB MIA79FLT04Accident · No injuriesClosedPiper PA-23 · Southaven, MSMar 10, 1979 · N1125P · Substantial damage NTSB DCA79AA011Accident · 8 fatalClosedBeech BE-70 · Gulfport, MSMar 1, 1979 · N777AE · Destroyed NTSB MIA79FA054Accident · 3 fatalClosedBeech 58 · Greenville, MSFeb 26, 1979 · N2055K · 2 aircraft · Destroyed NTSB MIA79FA046Accident · 1 fatalClosedPiper PA-23 · Pascagoula, MSFeb 4, 1979 · N3362P · Destroyed NTSB MIA79FLT03Accident · No injuriesClosedCessna 150 · Booneville, MSJan 25, 1979 · N8357U · Substantial damage NTSB MIA79FA035Accident · 1 fatalClosedCessna 310R · Madison, MSJan 5, 1979 · N303LA · Destroyed NTSB MIA79FLT02Accident · No injuriesClosedBell 47G5 · Paden, MSDec 19, 1978 · N4713R · Substantial damage NTSB MIA79FLT01Accident · Serious injuriesClosedBellanca 7GCAA · Walls, MSDec 18, 1978 · N8756V · Destroyed NTSB MIA79FKQ03Accident · No injuriesClosedCessna 182 · Bay St Louis, MSDec 12, 1978 · N444PP · Destroyed NTSB MIA79DKQ02Accident · Minor injuriesClosedCessna 172 · Ocean Springs, MSDec 3, 1978 · N78511 · Destroyed NTSB MIA79FA012Accident · 8 fatalClosedBeech 60 · Jackson, MSNov 6, 1978 · N135D · Destroyed NTSB MIA78DKQ01Accident · Minor injuriesClosedMooney M20J · Cleveland, MSOct 13, 1978 · N201GJ · Destroyed NTSB MIA78FKQ42Accident · No injuriesClosedCessna A188B · Leland, MSSep 29, 1978 · N9327R · Substantial damage NTSB MIA78DKQ41Accident · No injuriesClosedCessna 152 · Tylertown, MSSep 22, 1978 · N66946 · Substantial damage NTSB MIA78FKQ39Accident · Serious injuriesClosedCessna 188B · Inverness, MSSep 21, 1978 · N4783Q · Destroyed NTSB MIA78DKQ40Accident · No injuriesClosedGrumman G-164 · Hollybluff, MSSep 20, 1978 · N961X · Destroyed NTSB MIA78FA123Accident · 1 fatalClosedCessna 172N · Gautier, MSSep 11, 1978 · N666ZH · Destroyed NTSB MIA78FKQ38Accident · No injuriesClosedGrumman G-164 · Philipp, MSSep 7, 1978 · N482Y · Substantial damage NTSB UNK78X0135Accident · No injuriesClosedCessna A188B · Greenville, MSSep 2, 1978 · N6994G · Destroyed NTSB MIA78FKQ35Accident · Minor injuriesClosedCessna 150 · Biloxi, MSAug 26, 1978 · N1529Q · Substantial damage NTSB MIA78FKQ34Accident · No injuriesClosedCessna 188 · Brookhaven, MSAug 25, 1978 · N4814R · Destroyed NTSB MIA78FLT02Accident · No injuriesClosedMooney M-21 · Holly Spgs, MSAug 22, 1978 · N6088Q · Substantial damage NTSB MIA78DKQ33Accident · No injuriesClosedGrumman G-164B · Benton, MSAug 20, 1978 · N6645Q · Substantial damage NTSB MIA78FKQ32Accident · No injuriesClosedGrumman G-164A · Charleston, MSAug 14, 1978 · N8369 · Substantial damage NTSB MIA78DKQ31Accident · Minor injuriesClosedCessna 188 · Water Valley, MSAug 12, 1978 · N53319 · Substantial damage NTSB MIA78DKQ36Accident · No injuriesClosedPiper PA-18 · Mt.Olive, MSAug 5, 1978 · N3687P · Substantial damage NTSB MIA78FKQ29Accident · No injuriesClosedGrumman G-164B · Charlestown, MSAug 3, 1978 · N6780Q · Substantial damage NTSB MIA78FKQ28Accident · No injuriesClosedPiper PA-25 · Raymond, MSAug 3, 1978 · N4801Y · Substantial damage NTSB MIA78FK030Accident · Minor injuriesClosedGrumman G-164B · Charleston, MSAug 3, 1978 · N48497 · Destroyed