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 FTW66D0654Accident · No injuriesClosedPiper PA-25 · Crowley, LAMay 3, 1966 · N7350Z · Substantial damage NTSB FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LAMay 1, 1966 · N6595F · Destroyed NTSB FTW67F0027Accident · No injuriesClosedGrumman G164 · Abbeville, LAApr 29, 1966 · N468RF · Substantial damage NTSB FTW66F0644Accident · No injuriesClosedBeech E18S · Columbia, LAApr 21, 1966 · N650M · Substantial damage NTSB FTW66F0635Accident · No injuriesClosedBoeing E75N1 · Lake Charles, LAApr 19, 1966 · N75272 · Substantial damage NTSB FTW66D0637Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAApr 18, 1966 · N657U · Substantial damage NTSB FTW66D0623Accident · No injuriesClosedCessna 172 · Freemason Is, LAApr 8, 1966 · N7967B · Substantial damage NTSB FTW66F0564Accident · No injuriesClosedCessna 182 · New Orleans, LAApr 3, 1966 · N2402X · Substantial damage NTSB FTW66D0562Accident · No injuriesClosedPiper PA-25 · Belle Rose, LAMar 30, 1966 · N6254Z · Substantial damage NTSB FTW66F0580Accident · No injuriesClosedCessna 310 · New Orleans, LAMar 23, 1966 · N4877B · Substantial damage NTSB FTW66F0579Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAMar 19, 1966 · N8176D · Substantial damage NTSB FTW66A0080Accident · 2 fatalClosedPiper PA-30 · Lake Charles, LAMar 19, 1966 · N7355Y · Destroyed NTSB FTW66D0558Accident · No injuriesClosedCessna 185 · Baton Rouge, LAMar 17, 1966 · N1573F · Substantial damage NTSB FTW66F0556Accident · No injuriesClosedCessna 150 · New Orleans, LAMar 15, 1966 · N8504G · Destroyed NTSB FTW66F0537Accident · No injuriesClosedChampion 7FC · Kaplan, LAMar 15, 1966 · N4851E · Substantial damage NTSB FTW66F0576Accident · No injuriesClosedBeechcraft P35 · Lake Charles, LAMar 12, 1966 · N1555Z · Substantial damage NTSB FTW66D0528Accident · No injuriesClosedCessna 172 · Franklin, LAMar 12, 1966 · N5757A · Substantial damage NTSB FTW66A0078Accident · Serious injuriesClosedSikorsky S-62A · Venice, LAMar 10, 1966 · N324Y · 2 aircraft · Substantial damage NTSB FTW66F0518Accident · No injuriesClosedCessna 210E · New Orleans, LAMar 6, 1966 · N4957U · Substantial damage NTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LAMar 1, 1966 · N3521L · Substantial damage NTSB FTW66A0073Accident · No injuriesClosedDouglas DC-8 · New Orleans, LAFeb 27, 1966 · N814PA · Substantial damage NTSB FTW66F0547Accident · No injuriesClosedCessna 185C · Morgan City, LAFeb 26, 1966 · N2673Z · Substantial damage NTSB FTW66A0083Accident · No injuriesClosedBell 47G-2 · Lake Charles, LAFeb 25, 1966 · N8425E · Substantial damage NTSB FTW66F0546Accident · No injuriesClosedCessna 180E · Westwego, LAFeb 23, 1966 · N2680Y · Substantial damage NTSB FTW66F0566Accident · No injuriesClosedCessna 210 · Lafayette, LAFeb 22, 1966 · N502RE · Substantial damage NTSB FTW66F0533Accident · No injuriesClosedCessna 172 · Kaplan, LAFeb 22, 1966 · N5728R · Substantial damage NTSB FTW66F0510Accident · Serious injuriesClosedLuscombe 8A · Oak Grove, LAFeb 13, 1966 · N829B · Destroyed NTSB FTW66F0517Accident · No injuriesClosedCessna 185D · Bayou Sale, LAFeb 3, 1966 · N1512F · Substantial damage NTSB FTW66A0066Accident · No injuriesClosedBell 47J-2 · Cameron, LAJan 26, 1966 · N8490E · Destroyed NTSB FTW66F0474Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJan 16, 1966 · N8260X · Substantial damage NTSB FTW66F0491Accident · No injuriesClosedPiper PA-24 · Montgomery, LAJan 15, 1966 · N7950P · Substantial damage NTSB FTW66A0028Accident · Minor injuriesClosedBell 47G-2A · Port Sulphur, LAJan 11, 1966 · N7897B · Substantial damage NTSB FTW66A0062Accident · 1 fatalClosedPiper PA-24 · Jonesboro, LAJan 1, 1966 · N5783P · Destroyed NTSB FTW66F0473Accident · No injuriesClosedBeechcraft AT-11 · Monroe, LADec 29, 1965 · N556T · Substantial damage NTSB FTW66F0461Accident · Minor injuriesClosedCessna 150E · Florriessant, LADec 24, 1965 · N3059J · Substantial damage NTSB FTW66D0451Accident · No injuriesClosedCessna 310D · Thornwell, LADec 20, 1965 · N6899T · Substantial damage NTSB FTW66F0466Accident · Serious injuriesClosedPiper PA-32 · Alexandria, LADec 15, 1965 · N3341W · Destroyed NTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LADec 12, 1965 · N8897S · Substantial damage NTSB FTW66F0413Accident · No injuriesClosedPiper PA-24 · Natchitoches, LADec 8, 1965 · N6485P · Substantial damage NTSB FTW66F0412Accident · No injuriesClosedBeechcraft D95A · New Orleans, LADec 3, 1965 · N8965M · Substantial damage NTSB FTW66F0400Accident · No injuriesClosedBeechcraft D35 · Shreveport, LANov 25, 1965 · N2162D · Substantial damage NTSB FTW66A0046Accident · No injuriesClosedBell 47-J2A · Empire, LANov 15, 1965 · N3092G · Substantial damage NTSB FTW66F0379Accident · No injuriesClosedCessna 210D · New Orleans, LANov 13, 1965 · N3926Y · Substantial damage NTSB FTW66D0407Accident · No injuriesClosedPiper PA-18 · Timbalier Bay, LANov 13, 1965 · N3690P · Substantial damage NTSB FTW66F0376Accident · No injuriesClosedPiper PA-28 · Lafayette, LANov 5, 1965 · N7000W · Substantial damage NTSB FTW66F0360Accident · No injuriesClosedMooney M20E · Shreveport, LANov 1, 1965 · N6688R · Substantial damage NTSB FTW66F0405Accident · Serious injuriesClosedPiper PA-22 · Jennings, LAOct 29, 1965 · N6912B · Destroyed NTSB FTW66D0347Accident · No injuriesClosedAeronca 7AC · Tallulah, LAOct 27, 1965 · N83837 · Substantial damage NTSB FTW66A0037Accident · No injuriesClosedBell CHG2 · Vivian, LAOct 15, 1965 · N5235N · Substantial damage NTSB FTW66F0351Accident · No injuriesClosedBeechcraft 95-A55 · Alexandria, LAOct 8, 1965 · N1532Z · Substantial damage