NTSB investigations, LA
8 cases where the sequence of events included Aircraft inspection event.
Cases per year
| 2010 | 4 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2017 | 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…NTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB CEN11IA156Incident · No injuriesIncident investigationFinal reportSikorsky 92 · Galliano, LAThe misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.NTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.NTSB CEN10CA352Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Lake Charles, LAThe flight instructor’s inadvertent entry into ground resonance when demonstrating a hydraulic failure running landing, which resulted in substantial damage to the helicopter. Contributing to the accident was the pilot's and instructor pilot's failure to…NTSB CEN10IA169Incident · No injuriesIncident investigationFinal reportSikorsky S-92A · Galliano, LAAn unsecured access door, which departed the helicopter and damaged a main rotor blade and a tail rotor blade. Contributing to the incident was the helicopter's color scheme, which made visual inspection of the door difficult.