NTSB investigations, OH
6 cases where the sequence of events included Aircraft inspection event.
Cases per year
| 2010 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'OH' 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" = 'OH' 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 ERA22LA310Accident · No injuriesClass 3 · LimitedFinal reportCubcrafters CC11-160 · Findlay, OHThe pilot/mechanic’s inadequate inspection of the faulty horizontal stabilizer trim switch, which resulted in an uncommanded trim movement during the takeoff roll, which resulted in an aborted takeoff, and subsequent nose over.NTSB CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15LA303Accident · No injuriesLimited investigationFinal reportAviat A-1C-180 · Cincinnati, OHThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14LA233Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Lancaster, OHFuel starvation due to the deterioration of the fuel selector valve, which allowed fuel to be fed from only the right tip tank. Contributing to the accident was the inadequate annual inspection, which failed to detect the deteriorated valve.NTSB CEN14LA006Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Xenia, OHThe nose landing gear failure as a result of a fatigue fracture of the engine mount nose gear actuator feet in an area detailed in a service bulletin. Contributing to the accident was maintenance personnel’s inadequate completion of the inspection specified…NTSB ENG10IA016Incident · No injuriesIncident investigationFinal reportDouglas DC8 · Cincinnati (CVG), OHFailure of the NLG cylinder occurred by intergranular rupture; coincidental to a chrome plating crack. The failure origin occurred along the inner surface of the cylinder and then propagated by stress corrosion cracking to the outer surface. A secondary crack…