Fatal NTSB investigations: NONE
9 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with terrain/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 2002 | 3 |
| 2005 | 3 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.NTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.NTSB LAX02LA291Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-42-2 Jantar · Hemet, CAthe pilot's failure to maintain an adequate terrain clearance altitude.NTSB LAX02LA215Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS8-18 · Incline Village, NVthe pilot's inadequate in-flight planning and failure to maintain an adequate clearance from terrain.NTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.NTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…NTSB SEA84FA185Accident · 2 fatalField investigationFinal reportde Havilland Beaver DHC-2 · Ketchikan, AKThe plt flew into a canyon with a climb-out gradient in excess of the acft capability and collided with the upsloping terrain. The plt said he had hit a downdraft and turned away from the rising terrain just as collision occurred. Surviving passengers do not…NTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…