NTSB investigations, NC
6 cases where the sequence of events included Aircraft structural failure.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
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 c.\"eventStateOrRegion\" = 'NC' 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\" = '337' 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 c."eventStateOrRegion" = 'NC' 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" = '337' 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 ERA21LA014Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Rural Hall, NCThe pilot’s failure to maintain airplane control and improper recovery from an unusual attitude, which resulted in an in-flight breakup.NTSB ERA19FA188Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Castalia, NCThe pilot’s failure to navigate around hazardous weather, resulting in the penetration of a thunderstorm, a loss of airplane control, and an inflight breakup. The air traffic controller’s failure to provide the pilot with adequate and timely weather…NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…NTSB ENG09IA009Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte (CLT), NCThe failure of the left hand main landing gear was caused by heat induced cracks resulting from abusive grinding/polishing of the chrome plate that was applied during the last overhaul.NTSB NYC08FA260Accident · 2 fatalField investigationFinal reportPiper PA-23 · Highlands, NCThe pilot's improper decision to fly into an area of thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the air traffic controller's failure to comply with FAA directives regarding issuance of precipitation location and…NTSB NYC08FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta II · Wilmington, NCThe pilot's failure to maintain proper rotor rpm after a partial loss of engine power.