Skip to content

NTSB investigations, LA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW78DRD07Accident · Minor injuriesClosedCessna A188B · Le Blance, LANov 7, 1977 · N9313R · Destroyed NTSB FTW78FRJ05Accident · No injuriesClosedCessna 172 · Ruston, LANov 2, 1977 · N7123T · Substantial damage NTSB FTW78DRJ06Accident · No injuriesClosedPiper J3C · Pineville, LANov 2, 1977 · N71022 · Substantial damage NTSB FTW78DRJ04Accident · No injuriesClosedCessna 150 · Crowville, LAOct 26, 1977 · N22041 · Substantial damage NTSB FTW78FA005Accident · 1 fatalClosedBeech M35 · Dubach, LAOct 23, 1977 · N9840R · Destroyed NTSB FTW78DRD06Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LAOct 23, 1977 · N70273 · Substantial damage NTSB FTW78DRJ03Accident · No injuriesClosedBoeing 75N1 · Shreveport, LAOct 22, 1977 · N48579 · Substantial damage NTSB UNK78X0102Accident · No injuriesClosedBeech C24R · Freemason Isl, LAOct 21, 1977 · N24016 · Destroyed NTSB FTW78DRD03Accident · No injuriesClosedGrumman AA-5 · Lafayette, LAOct 12, 1977 · N5421L · Substantial damage NTSB FTW78DRJ02Accident · No injuriesClosedCessna 182A · Ruston, LAOct 11, 1977 · N38940 · Substantial damage NTSB FTW78DRJ01Accident · No injuriesClosedCessna A188B · Mansfield, LAOct 11, 1977 · N6380G · Substantial damage NTSB FTW78FA003Accident · 2 fatalClosedBell 206B · Grand Chenier, LAOct 10, 1977 · N157AL · Destroyed NTSB FTW78DRD04Accident · Minor injuriesClosedBolkow BO-105 · Intracoastal, LAOct 10, 1977 · N90760 · Destroyed NTSB FTW78FRD02Accident · No injuriesClosedCessna A188B · De Ridder, LAOct 4, 1977 · N8125G · Substantial damage NTSB FTW78DRD01Accident · Minor injuriesClosedBell 47G2A1 · Kenner, LAOct 1, 1977 · N3075G · Destroyed NTSB FTW77FRJ25Accident · No injuriesClosedAeronca 7AC · Jonesville, LASep 29, 1977 · N82375 · Destroyed NTSB FTW77FRJ24Accident · No injuriesClosedCessna 175A · Gilliam, LASep 28, 1977 · N6848E · Substantial damage NTSB FTW77FRD53Accident · No injuriesClosedPiper PA-28 · Leonville, LASep 27, 1977 · N1041Q · Substantial damage NTSB FTW77FRD52Accident · Minor injuriesClosedCessna 337A · Gonzales, LASep 24, 1977 · N90BD · Substantial damage NTSB FTW77DRJ76Accident · No injuriesClosedGrumman G-164A · Natchitoches, LASep 24, 1977 · N8623H · Destroyed NTSB FTW77FRD51Accident · No injuriesClosedLear 24 · Baton Rouge, LASep 16, 1977 · N56LS · Substantial damage NTSB FTW77DRD50Accident · No injuriesClosedCessna 180F · Houma, LASep 16, 1977 · N91476 · Substantial damage NTSB FTW77FRJ23Accident · 1 fatalClosedCessna 150M · Oil City, LASep 15, 1977 · N6199K · Destroyed NTSB FTW77DRJ22Accident · No injuriesClosedGrumman G-164A · Transylvania, LASep 2, 1977 · N9375 · Substantial damage NTSB FTW77FRJ20Accident · No injuriesClosedGrumman G-164A · Gilliam, LAAug 30, 1977 · N959X · Substantial damage NTSB FTW77DRD49Accident · No injuriesClosedGrumman G-164A · Grant, LAAug 28, 1977 · N9512 · Substantial damage NTSB FTW77FRD45Accident · Minor injuriesClosedBell 206B · Venice, LAAug 26, 1977 · N90151 · Destroyed NTSB FTW77DRJ21Accident · Serious injuriesClosedMurrayair MA-1 · Coushatta, LAAug 26, 1977 · N1020Y · Destroyed NTSB FTW77FRD48Accident · No injuriesClosedCessna 210M · Eunice, LAAug 25, 1977 · N732ZE · Substantial damage NTSB FTW77FRO44Accident · No injuriesClosedGrumman G-164A · Washington, LAAug 24, 1977 · N85124 · Substantial damage NTSB FTW77DRD47Accident · Minor injuriesClosedBell 47G-4A · Lafayette, LAAug 24, 1977 · N4004G · Destroyed NTSB FTW77FRJ19Accident · Serious injuriesClosedCessna 188B · Mer Rouge, LAAug 23, 1977 · N91432 · Destroyed NTSB FTW77FRD24Accident · Serious injuriesClosedGrumman G-164A · Ville Platte, LAAug 21, 1977 · N5264 · Destroyed NTSB FTW77FRJ17Accident · No injuriesClosedCessna A188B · Oak Ridge, LAAug 20, 1977 · N9602G · Substantial damage NTSB FTW77FA070Accident · 1 fatalClosedBeech V35B · Ida, LAAug 18, 1977 · N1605W · Destroyed NTSB FTW77DRJ18Accident · No injuriesClosedPiper PA-25 · Jonesville, LAAug 15, 1977 · N7470Z · Substantial damage NTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LAAug 8, 1977 · N5417 · Destroyed NTSB FTW77FRJ15Accident · Serious injuriesClosedLuscombe 8E · Shreveport, LAAug 6, 1977 · N2480K · Destroyed NTSB FTW77FRD43Accident · No injuriesClosedGrumman G-164 · Maringouin, LAAug 1, 1977 · N462RF · Destroyed NTSB FTW77FRD42Accident · Serious injuriesClosedPiper J3-C65 · Beaux Bridge, LAJul 31, 1977 · N71024 · Destroyed NTSB FTW77FRD40Accident · No injuriesClosedBell 206B · Venice, LAJul 28, 1977 · N2653 · Substantial damage NTSB FTW77FRJ13Accident · No injuriesClosedCessna 150L · Leesville, LAJul 25, 1977 · N5407Q · Substantial damage NTSB FTW77FRJ14Accident · No injuriesClosedGrumman G-164A · Lk Providence, LAJul 20, 1977 · N8950H · Destroyed NTSB FTW77FRD39Accident · No injuriesClosedGrumman G-164B · Baton Rouge, LAJul 11, 1977 · N6670Q · Substantial damage NTSB FTW77IA063Incident · No injuriesClosedDouglas DC-10 · New Orleans, LAJul 10, 1977 · N66NA · Minor damage NTSB FTW77FRD38Accident · No injuriesClosedCessna 150K · Gillis, LAJul 8, 1977 · N8382M · Substantial damage NTSB FTW77FRJ12Accident · No injuriesClosedBeech D55 · Natchitoches, LAJul 1, 1977 · N413S · Substantial damage NTSB FTW77DRJ11Accident · No injuriesClosedBoeing A75 · Marksville, LAJun 28, 1977 · N53280 · Substantial damage NTSB FTW77FRD37Accident · Serious injuriesClosedCessna 177 · New Orleans, LAJun 27, 1977 · N29387 · Destroyed NTSB FTW77FRD36Accident · No injuriesClosedCessna 180 · New Orleans, LAJun 20, 1977 · N9342T · Substantial damage