NTSB investigations: Quest KODIAK 100
5 cases on aircraft the registry lists as Quest KODIAK 100, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2012 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7320001', '7320005', '05622SV')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7320001', '7320005', '05622SV')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' 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" 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 ERA18FA092Accident · 2 fatalField investigationFinal reportQuest Kodiac 100 · Georgetown, FLThe pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.NTSB WPR17FA035Accident · 1 fatalField investigationFinal reportQuest Kodiak 100 · Moab, UTThe pilot's loss of control shortly after takeoff due to spatial disorientation.NTSB CEN16LA019Accident · Serious injuriesLimited investigationFinal reportQuest Kodiak 100 · Sheridan, WYThe loss of airplane control during takeoff for reasons that could not be determined based on the available information.NTSB ERA13LA360Accident · Minor injuriesLimited investigationFinal reportQuest Kodiak 100 · Westport, MAA failure to achieve a positive climb rate after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ANC12GA114Accident · No injuriesFinal reportQuest Kodiak 100 · Anchorage, AKThe pilot's failure to maintain directional control while landing, which resulted in a collision with the water. Contributing to the accident were the pilot's lack of experience conducting waterborne operations in the accident make and model airplane and the…