NTSB investigations, MA
8 cases where NTSB found Flight control system.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2025 | 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\" = 'MA' 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\", '010227'))
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" = 'MA' 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", '010227')) 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 ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB ERA17LA329Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Nantucket, MAThe separation of the pushrod from the elevator trim tab actuator, which rendered controlled flight impossible. Contributing to the separation of the pushrod was the failure of maintenance personnel to properly secure it to the elevator trim tab actuator.NTSB ERA15LA360Accident · No injuriesLimited investigationFinal reportJ. Schilling S-19 · East Falmouth, MAThe experimental airplane builder's failure to properly secure the stabilator trim tab push-pull tube’s connection, which resulted in the tube’s separation and a subsequent hard landing. Contributing to the accident was the pilot/owner's failure to detect the…NTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…NTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…NTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.NTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.NTSB NYC08FA218Accident · 1 fatalField investigationFinal reportDehavilland DHC6 · Hyannis, MAThe pilot's failure to remove the flight control lock prior to takeoff. Contributing to the accident was the Federal Aviation Administration's failure to issue an airworthiness directive making the manufacturer's previously-issued flight control lock service…