NTSB investigations, 2011
64 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases, newest first
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 year(c.\"eventDate\") = 2011
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' 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 year(c."eventDate") = 2011 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' 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 ERA11FA185Accident · 1 fatalField investigationFinal reportCessna 310R · Smyrna, TNThe pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.NTSB ERA11LA150Accident · Minor injuriesLimited investigationFinal reportFlaglor Tom Kolb Aircraft MK III · Stetson, METhe in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.NTSB CEN11FA193Accident · No injuriesField investigationFinal reportGulfstream Aerospace GV-SP · Appleton, WIThe pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…NTSB CEN11IA180Incident · No injuriesIncident investigationFinal reportHawker Beechcraft C90 · Evansville, INThe peel chip-type failure of the co-pilot's window during initial climb.NTSB CEN11LA173Accident · No injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe failure of the landing gear system for undetermined reasons.NTSB ERA11FA133Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 Magister · Kissimmee, FLThe pilot/mechanic's improper decision to continue a tight-turning landing pattern after a loss of hydraulic pressure, and his subsequent failure to maintain adequate airspeed during that pattern, which resulted in an accelerated maneuver stall. Contributing…NTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.NTSB ERA11CA125Accident · No injuriesData collectionFinal reportCessna 210K · Crestview, FLThe pilot's inability to maintain control of the airplane during landing due to the failure of the right main tire.NTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.NTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…NTSB DCA11WA023Incident · No injuriesForeign investigationBoeing 737 · Montpelier, FranceOn January 10, 2011, at 1330 local time a Boeing 737-700, registration F-GIXD experienced an AOA sensor blockage resulting in false stick-shaker during takeoff from Montpelier, France. The airplane was on a ferry flight to Toulouse, France, and returned to…NTSB WPR11LA119Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic · Palm Springs, CAInadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB CEN11CA143Accident · No injuriesData collectionFinal reportRardin William I Kitfox III · Carlisle, ARFailure of the left main landing gear strut due to a pre-existing crack in the weld joint.