NTSB investigations, 2020
4 cases where NTSB found Empennage structure.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 4 |
| 2010 | 9 |
| 2011 | 9 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 10 |
| 2025 | 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 year(c.\"eventDate\") = 2020
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010355'))
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") = 2020 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010355')) 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 CEN20LA294Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Harlan, IAThe fatigue fracture of the upper rudder hinge that resulted in a partial separation of the rudder from the airplane during a spray pass.NTSB ANC20LA059Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 12 · Anchorage, AKThe fatigue fracture of the American Iron and Steel Institute (AISI) 1025 carbon steel rudder post, which resulted in structural failure of the rudder. Contributing to the fatigue failure was the post’s susceptibility to fatigue cracking under normal service…NTSB DCA20LA107Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737 · Victorville, CAImproper installation of dorsal fin attach bolts which caused the dorsal fin to separate during flight, substantially damaging the left horizontal stabilizer.NTSB CEN20LA173Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado S · Haskell, OKThe student pilot/builder’s addition of winglets to the stabilator, which resulted in flutter and overstress failure of the stabilator control horn.