NTSB investigations, LA
12 cases where NTSB found Terrain.
Cases per year
| 2008 | 2 |
|---|---|
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 2 |
Where
Latest 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030210'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030210')) 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 CEN21LA072Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Elton, LAThe loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined based on available evidence.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.NTSB CEN20LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Shreveport, LAThe loss of engine power for undetermined reasons.NTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.NTSB CEN17FA281Accident · 1 fatalField investigationFinal reportCessna 150F · Farmerville, LAThe pilot's failure to maintain clearance from the lake during a low-level maneuver.NTSB CEN16LA118Accident · No injuriesLimited investigationFinal reportCessna 150G · Simmesport, LAThe installation of an improper bearing and thrust washer during engine overhaul, which resulted in failure of the connecting rods and a subsequent total loss of engine power.NTSB CEN16LA064Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sulphur, LAThe loss of engine power due to water and contaminants in the carburetor, which resulted in a forced landing to a wet field.NTSB CEN15LA265Accident · No injuriesLimited investigationFinal reportBell 407 · Pecan Island, LAThe fatigue fracture of the tail rotor gearbox attachment studs, which resulted in a loss of tail rotor control and a subsequent hard landing.NTSB DFW08CA235Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Patterson, LAThe loss of engine power due to fuel contamination. Contributing to the accident was the unsuitable muddy terrain for the forced landing.NTSB DFW08CA207Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Abbeville, LAA total loss of engine power for undetermined reasons. Contributing to the accident was unsuitable terrain for a forced landing.