Major NTSB investigations, LA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.
Cases per year
| 1969 | 1 |
|---|---|
| 1972 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2009 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
Query with SQL
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'
AND (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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' AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…NTSB DCA94MA033Accident · Minor injuriesClass 1 · MajorFinal reportSaab-Scania 340B · New Roads, LAThe captain's movement of the power levers below flight idle in flight, the inadequate certification requirements and consequent design of the airplane's power levers that permitted them to be moved below the flight idle position into the beta range, either…NTSB FTW88MA047Accident · 2 fatalMajor investigationFinal reportGates Learjet 36A · Monroe, LAThe crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…NTSB LAX72AL043Accident · Serious injuriesClosedBoeing 747 · Lake Charles, LANTSB DCA69A0015Accident · 16 fatalClosedDouglas DC3A · New Orleans, LA