NTSB investigations, NC
8 cases where the sequence of events included Aircraft inspection event.
Cases per year
| 2013 | 2 |
|---|---|
| 2014 | 1 |
| 2015 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 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\" = '050' 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" = '050' 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 ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB ERA22LA258Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D1 · Pittsboro, NCThe student pilot, and flight instructor’s, inadequate preflight inspection, during which they failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB ERA15CA321Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Pittsboro, NCThe pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.NTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.NTSB ERA14CA335Accident · No injuriesData collectionFinal reportAlexander Schleicher K 7 · Mocksville, NCThe pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…NTSB ERA14LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Franklin, NCThe failure of the left main landing gear brake line during landing due to the loss of hydraulic fluid. Contributing to the accident was a fatigue crack through the brake line that had formed due to contact with a swaged sleeve as a result of exfoliation…NTSB ERA13LA405Accident · Minor injuriesLimited investigationFinal reportCrowder Michael H Sonex · Waxhaw, NCThe pilot/owner/builder’s improper routing of the engine’s crankshaft position sensor cable next to the engine’s exhaust system, which resulted in a total loss of engine power in flight.