NTSB investigations, WV
6 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 3 |
| 2006 | 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\" = 'WV' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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" = 'WV' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…NTSB BFO89LA010Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Dublin, WVThe pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding…NTSB ATL89FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bridgeport, WVThe plt was cleared to execute a visual approach to rwy 21 and was issued the current alt setting of 29.60' hg. The approach was made under dark night and gusty crosswind conditions to a lighted runway in rural mountainous/hilly terrain. During final approach…NTSB BFO88IA057Incident · 1 fatalIncident investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot died from coronary disease while practicing landings.NTSB CHI87FA018Accident · Serious injuriesField investigationFinal reportGates Learjet 23 · Charleston, WVThe PIC lost consciousness during cruise near Charleston WV while on a revenue flt. The co-plt assumed command and landed at Charleston WV without further incident. The PIC was hospitalized and the flt continued on to detroit mi after a replacement PIC was…NTSB ATL84IA137Incident · 2 fatalIncident investigationFinal reportPiper PA-34-200T · Parkersburg, WVAfter an unscheduled landing due to the condition of a patient aboard the acft, the acft turned off a taxiway into the grass and stopped. Rescue personnel found the plt incapacitated from a heart attack and collapsed over the controls and the nurse…