NTSB investigations, GA
12 cases where NTSB found Pitch control.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 3 |
| 2012 | 1 |
| 2015 | 1 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 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\" = 'GA' 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" = 'GA' 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 ERA19FA134Accident · 1 fatalClass 2 · FieldFinal reportHogan Innovator · Calhoun, GAThe pilot's failure to maintain aircraft control during the airplane's second test flight, which resulted in a collision with terrain. Contributing to the accident was the pilot allowing external pressures to guide his decision to fly the airplane when he…NTSB GAA19CA020Accident · No injuriesData collectionFinal reportCessna 172 · Lawrenceville, GAThe student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB GAA17CA330Accident · No injuriesData collectionFinal reportBoeing B75N1 · Williamson, GAThe pilot’s aggressive and early forward stick application during the landing roll, which resulted in his failure to maintain pitch control and a subsequent nose-over.NTSB GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.NTSB ERA17FA118Accident · 1 fatalField investigationFinal reportCessna 421 · Canton, GAThe pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.NTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.NTSB ERA13CA098Accident · Minor injuriesData collectionFinal reportMckay Gene RV-9A · Brunswick, GAThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB ERA10LA483Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Clyo, GAThe pilot's failure to maintain a proper aircraft pitch attitude during the takeoff roll, which allowed the tailwheel to contact the grass runway and increase drag on the airplane.NTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.NTSB ERA10CA282Accident · No injuriesData collectionFinal reportCessna 172S · Jekyll Island, GAThe pilot's loss of airplane control while landing with a crosswind.NTSB ERA09CA484Accident · No injuriesData collectionFinal reportPiper PA-34 · Savannah, GAThe student pilot's failure to maintain pitch control during landing and the flight instructor's delayed remedial action, resulting in a hard landing.