NTSB investigations, AL
5 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 3 |
| 2015 | 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\" = 'AL' 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\" = '333' 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" = 'AL' 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" = '333' 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 ERA16LA015Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Dickinson, ALThe improper installation by company maintenance personnel of the securing hardware of a tail rotor driveshaft section, which resulted in that section of tail rotor driveshaft disconnecting and a complete loss of tail rotor thrust.NTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB CEN11IA111Incident · No injuriesIncident investigationFinal reportCessna 560XL · Birmingham, ALThe manufacturer's inadequate initial design and inadequate subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during operations in subfreezing temperatures, resulting in a loss of rudder authority…