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 FTW70A0003Accident · 1 fatalClosedPiper PA-22 · Sulphur, LAJul 22, 1969 · N3583A · Destroyed NTSB FTW70D0106Accident · Minor injuriesClosedCessna 150J · Florien, LAJul 11, 1969 · N51384 · Substantial damage NTSB FTW70F0129Accident · Minor injuriesClosedPiper PA-28 · St.Martinville, LAJul 10, 1969 · N4916L · Substantial damage NTSB FTW70F0077Accident · No injuriesClosedPiper PA-12 · Cottonport, LAJul 3, 1969 · N7903H · Destroyed NTSB FTW69A0087Accident · 2 fatalClosedPiper J3C-65 · Gurley, LAJun 28, 1969 · N3665K · Destroyed NTSB FTW70D0038Accident · No injuriesClosedCessna 182 · St Francisvile, LAJun 26, 1969 · N2678F · Substantial damage NTSB FTW70F0022Accident · 1 fatalClosedBell 47D1 · Livingston, LAJun 24, 1969 · N3111G · Destroyed NTSB FTW70F0063Accident · Minor injuriesClosedGrumman G-164 · Kaplan, LAJun 23, 1969 · N520Y · Substantial damage NTSB FTW70F0037Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAJun 22, 1969 · N8222N · Substantial damage NTSB FTW70D0091Accident · No injuriesClosedPiper PA-28 · Marksville, LAJun 22, 1969 · N6940W · Substantial damage NTSB FTW70F0035Accident · No injuriesClosedTravel Air D4000 · Tallulah, LAJun 20, 1969 · N9907 · Substantial damage NTSB FTW70F0059Accident · Minor injuriesClosedGrumman G-164 · Lake Arthur, LAJun 19, 1969 · N552Y · Substantial damage NTSB FTW70D0012Accident · No injuriesClosedCessna 177 · Kaplan, LAJun 14, 1969 · N2298Y · Substantial damage NTSB FTW70F0033Accident · No injuriesClosedMooney M20F · Baton Rouge, LAJun 8, 1969 · N6485Q · Substantial damage NTSB FTW70F0016Accident · No injuriesClosedLuscombe 8A · New Orleans, LAJun 8, 1969 · N72059 · Substantial damage NTSB FTW70F0048Accident · No injuriesClosedCessna 172H · Oil City, LAJun 7, 1969 · N1490F · Substantial damage NTSB FTW70F0015Accident · Serious injuriesClosedCessna A188 · Vinton, LAJun 5, 1969 · N3560Q · Destroyed NTSB FTW70F0013Accident · No injuriesClosedSnow S2C · Lake Arthur, LAJun 2, 1969 · N1651S · Substantial damage NTSB FTW70D0084Accident · No injuriesClosedCessna 150 · Natchitoches, LAMay 28, 1969 · N8631S · Substantial damage NTSB FTW70F0005Accident · Serious injuriesClosedBoeing E75N1 · Oberlin, LAMay 26, 1969 · N52967 · Substantial damage NTSB FTW69D0548Accident · Minor injuriesClosedCessna 180 · New Iberia, LAMay 20, 1969 · N4698U · Substantial damage NTSB FTW69D0544Accident · Serious injuriesClosedPiper PA-25 · Morganza, LAMay 20, 1969 · N4379Y · Destroyed NTSB FTW69F0547Accident · No injuriesClosedBeech E18S · New Orleans, LAMay 19, 1969 · N516K · Substantial damage NTSB FTW69F0541Accident · No injuriesClosedBoeing D75N1 · Elton, LAMay 19, 1969 · N47896 · Substantial damage NTSB FTW69F0465Accident · No injuriesClosedGrumman G-164 · Lake Charles, LAApr 29, 1969 · N10275 · Substantial damage NTSB FTW69F0457Accident · No injuriesClosedPiper PA-28 · Abbeville, LAApr 25, 1969 · N9754J · Substantial damage NTSB FTW69F0464Accident · No injuriesClosedGrumman G-164A · Oberlin, LAApr 22, 1969 · N5295 · Substantial damage NTSB FTW69F0462Accident · Minor injuriesClosedGrumman G-164 · Kaplan, LAApr 16, 1969 · N10278 · Destroyed NTSB FTW70D0043Accident · No injuriesClosedCessna 175 · Flora, LAApr 9, 1969 · N6634E · Substantial damage NTSB FTW69F0439Accident · No injuriesClosedCessna 170A · Rayne, LAApr 7, 1969 · N4403V · Substantial damage NTSB FTW69F0467Accident · No injuriesClosedCessna 120 · Ruston, LAApr 6, 1969 · N77327 · Substantial damage NTSB FTW69F0436Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAApr 3, 1969 · N6761J · Substantial damage NTSB FTW69F0412Accident · No injuriesClosedPiper PA-32 · Sarepta, LAMar 31, 1969 · N3853W · Substantial damage NTSB FTW69A0067Accident · 5 fatalClosedBeech S35 · Mansfield, LAMar 30, 1969 · N5736K · Destroyed NTSB FTW69F0411Accident · No injuriesClosedAero Comdr 200-D · Bogalusa, LAMar 25, 1969 · N2954T · Substantial damage NTSB FTW69A0064Accident · 1 fatalClosedBell 47J · Patterson, LAMar 25, 1969 · N2893B · Destroyed NTSB FTW69D0425Accident · Minor injuriesClosedCessna 210D · Patterson, LAMar 21, 1969 · N3808Y · Destroyed NTSB DCA69A0015Accident · 16 fatalClosedDouglas DC3A · New Orleans, LAMar 20, 1969 · N142D · Destroyed NTSB FTW69D0421Accident · No injuriesClosedGrumman G-164 · Lake Charles, LAMar 19, 1969 · N10275 · Substantial damage NTSB FTW69D0420Accident · Minor injuriesClosedBell 47G-4A · Houma, LAMar 17, 1969 · N1377X · Substantial damage NTSB FTW69F0401Accident · Minor injuriesClosedBeech S35 · New Orleans, LAMar 13, 1969 · N5601K · Substantial damage NTSB FTW69D0408Accident · No injuriesClosedCessna 150 · Ruston, LAMar 5, 1969 · N8430J · Substantial damage NTSB FTW69A0062Accident · 2 fatalClosedPiper J3C-65 · Tallulah, LAMar 2, 1969 · N55008 · Destroyed NTSB FTW69F0393Accident · Serious injuriesClosedBeech A23-19 · Gueydan, LAMar 1, 1969 · N6947Q · Destroyed NTSB FTW69D0486Accident · No injuriesClosedPiper J5 · Hammond, LAMar 1, 1969 · N41396 · Substantial damage NTSB FTW69F0423Accident · No injuriesClosedGrumman G-164A · Ville Platte, LAFeb 26, 1969 · N967X · Destroyed NTSB FTW69F0388Accident · No injuriesClosedStinson 108-1 · Kaplan, LAFeb 9, 1969 · N8766K · Substantial damage NTSB FTW69D0372Accident · No injuriesClosedCessna 206 · Simmesport, LAJan 27, 1969 · N8031Z · Substantial damage NTSB FTW69A0050Accident · 1 fatalClosedCessna 150J · Farmerville, LAJan 24, 1969 · N50468 · Destroyed NTSB FTW69F0361Accident · No injuriesClosedCessna 150H · Ruston, LAJan 22, 1969 · N23439 · Substantial damage