Skip to content

NTSB investigations, LA

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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 FTW67A0106Accident · No injuriesClosedBell 47J-2A · Morgan City, LAApr 24, 1967 · N8583F · Substantial damage NTSB FTW67D0566Accident · No injuriesClosedCessna 180 · Bayou Sorrel, LAApr 23, 1967 · N2610Y · Substantial damage NTSB FTW67F0540Accident · Serious injuriesClosedGrumman G-164 · Church Point, LAApr 22, 1967 · N621U · Destroyed NTSB FTW68F0201Accident · No injuriesClosedCessna 185A · Houma, LAApr 12, 1967 · N4746Q · Substantial damage NTSB FTW67D0669Accident · No injuriesClosedPiper PA-30 · Monroe, LAApr 12, 1967 · N7734Y · Substantial damage NTSB FTW67A0101Accident · No injuriesClosedHughes 269A · New Orleans, LAApr 11, 1967 · N8824F · Substantial damage NTSB FTW67D0528Accident · No injuriesClosedCessna 150 · Lafayette, LAApr 1, 1967 · N8918S · Substantial damage NTSB DCA67A0007Accident · 6 fatalClosedDouglas DC-8 · Kenner, LAMar 30, 1967 · N802E · Destroyed NTSB FTW67F0501Accident · No injuriesClosedMooney MK-20A · Rayville, LAMar 29, 1967 · N6059X · Substantial damage NTSB FTW67A0096Accident · No injuriesClosedBell 204-B · Vinton, LAMar 12, 1967 · N1177W · Substantial damage NTSB FTW67D0516Accident · No injuriesClosedCessna 182 · Ferriday, LAMar 10, 1967 · N3030Y · Substantial damage NTSB FTW67F0447Accident · No injuriesClosedPiper PA-28 · Amelia, LAMar 2, 1967 · N7448R · Substantial damage NTSB FTW67A0095Accident · No injuriesClosedBeech C-45H · New Orleans, LAFeb 27, 1967 · N9304Z · Substantial damage NTSB FTW67F0445Accident · No injuriesClosedCessna 150 · Lafayette, LAFeb 14, 1967 · N8918S · Substantial damage NTSB FTW67A0084Accident · 1 fatalClosedCessna 180 · Catahoula, LAFeb 13, 1967 · N53650 · Destroyed NTSB FTW67A0083Accident · No injuriesClosedHawker-Sdly DH125 · New Orleans, LAFeb 11, 1967 · N142B · Substantial damage NTSB FTW67D0457Accident · No injuriesClosedMooney M20C · Slidell, LAFeb 7, 1967 · N78996 · Substantial damage NTSB FTW67D0418Accident · No injuriesClosedCessna 172 · Buras, LAFeb 2, 1967 · N4405L · Substantial damage NTSB FTW67D0417Accident · No injuriesClosedCessna 180H · Franklin, LAJan 31, 1967 · N2486F · Substantial damage NTSB FTW67D0425Accident · No injuriesClosedCessna 140 · Baton Rouge, LAJan 30, 1967 · N72844 · Substantial damage NTSB FTW67F0435Accident · No injuriesClosedCessna 170A · New Orleans, LAJan 28, 1967 · N9908A · Substantial damage NTSB FTW67D0413Accident · No injuriesClosedAeronca 11AC · Shreveport, LAJan 27, 1967 · N9417E · Substantial damage NTSB FTW67A0077Accident · 1 fatalClosedMooney M20E · New Orleans, LAJan 21, 1967 · N2670W · Destroyed NTSB FTW67A0073Accident · No injuriesClosedBell 47J · Grande Isle, LAJan 10, 1967 · N2861B · Substantial damage NTSB FTW67F0383Accident · No injuriesClosedBeech TC-45G · Kenner, LAJan 6, 1967 · N7202C · Substantial damage NTSB FTW67D0397Accident · No injuriesClosedPiper PA-28 · Bogalusa, LADec 27, 1966 · N7866W · Substantial damage NTSB FTW67F0376Accident · Serious injuriesClosedPiper PA-25 · Moreauville, LADec 24, 1966 · N6642Z · Destroyed NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67F0360Accident · No injuriesClosedDehavilland 1142X · New Orleans, LADec 18, 1966 · N782R · Substantial damage NTSB FTW67A0065Accident · No injuriesClosedBell 204-B · Morgan City, LADec 18, 1966 · N8540F · Substantial damage NTSB FTW67A0063Accident · 1 fatalClosedCessna 150 · New Orleans, LADec 8, 1966 · 7Q-YFC · Destroyed NTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LADec 3, 1966 · N8185T · Destroyed NTSB FTW67D0321Accident · No injuriesClosedCessna 310" · Houma, LANov 30, 1966 · N6686B · Substantial damage NTSB FTW67D0315Accident · No injuriesClosedCessna 180 · Venice, LANov 16, 1966 · N5104E · Substantial damage NTSB FTW67D0314Accident · No injuriesClosedPiper PA-23 · Eunice, LANov 13, 1966 · N6209Y · Substantial damage NTSB FTW67A0050Accident · Serious injuriesClosedHughes 269B · New Orleans, LANov 9, 1966 · N9334F · Destroyed NTSB FTW67A0046Accident · Minor injuriesClosedDouglas DC-8 · New Orleans, LAOct 22, 1966 · N808E · Substantial damage NTSB FTW67D0248Accident · No injuriesClosedPiper PA-32 · Freemason Isl., LAOct 15, 1966 · N3520W · Substantial damage NTSB FTW67F0261Accident · No injuriesClosedAero Cmdr 520 · Houma, LAOct 14, 1966 · N4170B · Substantial damage NTSB FTW67D0288Accident · No injuriesClosedCessna 210A · New Orleans, LAOct 14, 1966 · N6685X · Substantial damage NTSB FTW67F0226Accident · No injuriesClosedLear Jet 23 · New Orleans, LAOct 10, 1966 · N242WT · Substantial damage NTSB FTW67A0043Accident · 11 fatalClosedBell 204B · Morgan City, LAOct 8, 1966 · N1187W · Destroyed NTSB FTW67F0307Accident · No injuriesClosedCessna 180 · Bayou Sorrel, LASep 29, 1966 · N3237D · Destroyed NTSB FTW67D0272Accident · No injuriesClosedBoeing A75 · Monroe, LASep 24, 1966 · N141J · Substantial damage NTSB FTW67D0219Accident · No injuriesClosedCessna 172 · Hammond, LASep 23, 1966 · N5740A · Substantial damage NTSB FTW67A0039Accident · 1 fatalClosedPiper J-3 · Kaplan, LASep 23, 1966 · N98571 · Destroyed NTSB FTW67A0038Accident · No injuriesClosedBell 47J · Leeville, LASep 23, 1966 · N6736D · Substantial damage NTSB FTW67D0255Accident · No injuriesClosedMooney M21 · Winnfield, LASep 22, 1966 · N6872U · Substantial damage NTSB FTW67A0037Accident · No injuriesClosedBell 47J-2A · Leeville, LASep 22, 1966 · N3092G · Substantial damage NTSB FTW67F0235Accident · No injuriesClosedErcoupe 415-C · Shreveport, LASep 21, 1966 · N99649 · Substantial damage