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 MIA74DKQ21Accident · No injuriesClosedCessna A188A · Duncan, MSMay 13, 1974 · N99356 · Substantial damage NTSB MIA74DKQ20Accident · No injuriesClosedBellanca 7KCAB · Sunflower, MSMay 9, 1974 · N57654 · Substantial damage NTSB MIA74AM089Accident · 4 fatalClosedPiper PA-28R · Bay St Louis, MSMay 4, 1974 · N54413 · Destroyed NTSB MIA74DKQ19Accident · No injuriesClosedCessna 150G · Bolton, MSMay 1, 1974 · N3623J · Substantial damage NTSB MIA74FKQ18Accident · Serious injuriesClosedCessna 150L · Hattiesburg, MSApr 28, 1974 · N1777Q · Destroyed NTSB MIA74FKQ17Accident · No injuriesClosedAmer Avco AA-1B · Jackson, MSApr 18, 1974 · N6268L · Substantial damage NTSB MIA74FKQ16Accident · No injuriesClosedSwearingen SA226T · Jackson, MSApr 5, 1974 · N3335G · Substantial damage NTSB MIA74DKQ15Accident · No injuriesClosedCessna 172 · Gunnison, MSMar 17, 1974 · N35469 · Substantial damage NTSB MIA74FKQ14Accident · Serious injuriesClosedPiper PA-28 · Collinsville, MSMar 15, 1974 · N3964K · Destroyed NTSB MIA74FKQ13Accident · Serious injuriesClosedPiper PA-25 · Crawford, MSMar 11, 1974 · N8901L · Destroyed NTSB MIA74FKQ12Accident · Minor injuriesClosedCessna 150F · Batesville, MSMar 7, 1974 · N3538L · Substantial damage NTSB MIA74DLT04Accident · Minor injuriesClosedCessna 150 · Corinth, MSFeb 9, 1974 · N5260Q · Substantial damage NTSB NYC74AN063Accident · 1 fatalClosedPiper PA-28R · Jackson, MSJan 8, 1974 · N859AP · Destroyed NTSB MIA74FKQ11Accident · Minor injuriesClosedBoeing E75 · Jackson, MSDec 3, 1973 · N131J · Destroyed NTSB MIA74AM040Accident · 1 fatalClosedPiper PA-28 · Columbus, MSNov 7, 1973 · N9508W · Destroyed NTSB MIA74AM030Accident · 1 fatalClosedLuscombe 8A · Natchez, MSOct 10, 1973 · N45915 · Destroyed NTSB MIA74AM028Accident · 2 fatalClosedCessna 150H · Gulfport, MSOct 3, 1973 · N23286 · Destroyed NTSB MIA74DKQ10Accident · No injuriesClosedCessna 188 · Lambert, MSSep 15, 1973 · N4468Q · Substantial damage NTSB MIA74AM022Accident · 4 fatalClosedCessna TU206C · Laurel, MSSep 11, 1973 · 8R-GDF · Destroyed NTSB MIA74FK608Accident · Serious injuriesClosedAeronca 7AC · Belzoni, MSSep 8, 1973 · N84703 · Destroyed NTSB MIA74DKQ09Accident · No injuriesClosedPiper PA-25 · Rosedale, MSSep 8, 1973 · N7498Z · Substantial damage NTSB MIA74FLT02Accident · No injuriesClosedCallair A-9 · Coldwater, MSSep 5, 1973 · N9655Z · Substantial damage NTSB MIA74FLT01Accident · No injuriesClosedGrumman G-164A · Ripley, MSSep 3, 1973 · N4562 · Substantial damage NTSB MIA74FKQ06Accident · 1 fatalClosedCessna A188B · Vaiden, MSAug 20, 1973 · N4492Q · Destroyed NTSB MIA74FKQ07Accident · No injuriesClosedAero Comdr A-9B · Yazoo City, MSAug 19, 1973 · N7745V · Destroyed NTSB MIA74DKQ05Accident · No injuriesClosedAero Comdr A9-B · Edwards, MSAug 17, 1973 · N7691V · Substantial damage NTSB MIA74AM014Accident · 4 fatalClosedPiper PA-24 · Gulfport, MSAug 12, 1973 · N6993P · Destroyed NTSB MIA74FKQ04Accident · Minor injuriesClosedTaylorcraft BC12-D · Amory, MSJul 31, 1973 · N96145 · Substantial damage NTSB MIA74AM010Accident · 2 fatalClosedAlon A-2 · Blue Springs, MSJul 28, 1973 · N6371V · Destroyed NTSB MIA74FKQ03Accident · Serious injuriesClosedCessna A188A · Marks, MSJul 24, 1973 · N9942G · Substantial damage NTSB MIA74AM005Accident · 1 fatalClosedAeronca 7AC · Oxford, MSJul 18, 1973 · N3603E · Destroyed NTSB MIA73FKQ02Accident · Serious injuriesClosedGrumman G-164A · Charleston, MSJul 13, 1973 · N4642 · Destroyed NTSB MIA74DKQ01Accident · Serious injuriesClosedBoeing B75NI · Rolling Fork, MSJul 5, 1973 · N1352M · Destroyed NTSB MIA73FKQ33Accident · No injuriesClosedGrumman G-164A · Boyle, MSJun 27, 1973 · N8389 · Destroyed NTSB MIA73FKQ30Accident · No injuriesClosedBell 47G2-2 · Grenada, MSJun 25, 1973 · N4823 · Substantial damage NTSB MIA73FKQ32Accident · No injuriesClosedCessna A188A · Crowder, MSJun 23, 1973 · N99156 · Destroyed NTSB MIA73FKQ31Accident · No injuriesClosedHughes 269B · Madison, MSJun 19, 1973 · N9357F · Substantial damage NTSB MIA73AM107Accident · 1 fatalClosedChampion 7GCAA · Walls, MSJun 10, 1973 · N2758G · Destroyed NTSB MIA73FKQ29Accident · No injuriesClosedGrumman G-164A · Minter City, MSJun 4, 1973 · N5333 · Destroyed NTSB MIA73FKQ28Accident · No injuriesClosedCessna 150 · Wiggins, MSMay 10, 1973 · N7821F · Substantial damage NTSB MIA73FKQ27Accident · Serious injuriesClosedAero Comdr A-9 · Flora, MSMay 4, 1973 · N8410V · Destroyed NTSB MIA73DKQ26Accident · No injuriesClosedCessna 177 · Clarksdale, MSMay 3, 1973 · N29668 · Destroyed NTSB MIA73FKQ25Accident · Serious injuriesClosedCessna 150 · Avon, MSMar 8, 1973 · N2611J · Substantial damage NTSB MIA73FKQ24Accident · No injuriesClosedCessna A188 · Lexington, MSFeb 27, 1973 · N21886 · Substantial damage NTSB MIA73AM070Accident · 2 fatalClosedCessna 150 · Meridian, MSJan 5, 1973 · N6884G · Destroyed NTSB MIA73FRQ23Accident · Minor injuriesClosedCessna 182E · Mccomb, MSDec 26, 1972 · N3288Y · Destroyed NTSB MIA73FLT14Accident · No injuriesClosedBeech D18S · Tunica, MSDec 14, 1972 · TG-HIH · Destroyed NTSB MIA73AM073Accident · 1 fatalClosedCessna 172 · Biloxi, MSDec 12, 1972 · N8015B · Destroyed NTSB MIA73AM061Accident · 1 fatalClosedAero Comdr 560-E · Tupelo, MSDec 11, 1972 · N2690B · Destroyed NTSB MIA73FKQ22Accident · No injuriesClosedCessna 172K · Picayune, MSDec 9, 1972 · N7027G · Substantial damage