NTSB investigations, 2014, TX
14 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 8 |
| 2010 | 7 |
| 2011 | 6 |
| 2012 | 12 |
| 2013 | 7 |
| 2014 | 14 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 6 |
| 2018 | 9 |
| 2019 | 12 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 9 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 3 |
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\") = 2014
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2014 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN15LA078Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Houston, TXThe nose landing gear collapse as a result of the fracture of the engine mount at the nose gear actuator attachment point in an area that a service bulletin (SB) recommended for inspection. Contributing to the accident was maintenance personnel’s inadequate…NTSB CEN15LA053Accident · Minor injuriesLimited investigationFinal reportBeech 58P · San Antonio, TXThe pilot’s improper decision to land long (past the midpoint) on a wet runway and his failure to conduct a go-around when the airplane did not touch down at the approach end of the runway, which resulted in an overrun.NTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB CEN14CA384Accident · No injuriesData collectionFinal reportCessna T206H · Sterling City, TXThe pilot's failure to maintain directional control of the airplane during the crosswind landing.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14CA343Accident · Minor injuriesData collectionFinal reportCessna 170B · Tomball, TXThe pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.NTSB CEN14LA276Accident · No injuriesLimited investigationFinal reportCessna 172N · Padre Island, TXThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN14LA226Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Greenville, TXThe fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.NTSB CEN14LA220Accident · No injuriesLimited investigationFinal reportPiper PA 34-200 · Spring, TXThe loss of right brake effectiveness during landing for reasons that could not be determined based on the available evidence, which resulted in a loss of directional control.NTSB CEN14LA213Accident · Serious injuriesLimited investigationFinal reportCrow Mustang II · Morton, TXThe pilot's improper landing flare after encountering a gusting crosswind and his inadequate recovery from the subsequent bounced landing.NTSB CEN14LA136Accident · Serious injuriesLimited investigationFinal reportMahon Paul D Capella XS · Houston, TXThe loss of engine power due to carburetor icing.NTSB CEN14LA133Accident · No injuriesLimited investigationFinal reportCessna 182A · Lexington, TXThe pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.