NTSB investigations, MN
9 cases where NTSB found Pitch control.
Cases per year
| 2009 | 2 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
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\" = 'MN' 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\", '01062022'))
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" = 'MN' 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", '01062022')) 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 CEN17LA304Accident · Serious injuriesLimited investigationFinal reportRoger M Allen RA2 · Hector, MNThe pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight.NTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.NTSB GAA16CA256Accident · No injuriesData collectionFinal reportCirrus Design SR20 · South St Paul, MNThe pilot's excessive nose high pitch attitude, which resulted in a tail strike during the landing flare.NTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…NTSB GAA16CA050Accident · No injuriesData collectionFinal reportCessna 182Q · Bowstring, MNThe pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with a wind sock and terrain.NTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.NTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.NTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.NTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.