NTSB investigations, 2012
11 cases where NTSB found Fence/fence post.
Cases per year
| 2008 | 35 |
|---|---|
| 2009 | 17 |
| 2010 | 16 |
| 2011 | 6 |
| 2012 | 11 |
| 2013 | 11 |
| 2014 | 20 |
| 2015 | 27 |
| 2016 | 30 |
| 2017 | 34 |
| 2018 | 26 |
| 2019 | 22 |
| 2020 | 12 |
| 2021 | 9 |
| 2022 | 11 |
| 2023 | 10 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 6 |
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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022047'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022047')) 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 WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB CEN12LA630Accident · No injuriesLimited investigationFinal reportHalderman, Floyd G. RV-6A · Eldon, MOThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.NTSB WPR12FA326Accident · 3 fatalField investigationFinal reportBeech B60 · Sedona, AZThe airplane’s failure to rotate and the pilot’s failure to reject the takeoff, which resulted in a runway overrun for reasons that could not be undetermined because postaccident examination of the airplane and engines did not reveal any malfunctions or…NTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.NTSB CEN12LA445Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro SportCruiser · Waynesville, OHThe airplane's collision with fence posts during an aborted takeoff due to a sudden change in wind direction.NTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.NTSB WPR12CA166Accident · Minor injuriesData collectionFinal reportMooney M20B · Rosamond, CAA loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.NTSB CEN12CA201Accident · No injuriesData collectionFinal reportJoy Vans RV-6 · McKinney, TXThe pilot did not maintain control of the airplane during takeoff, which resulted in a ground collision with airport construction materials.