NTSB investigations: Dehavilland DHC-8-202
5 cases on aircraft the registry lists as Dehavilland DHC-8-202. 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
| 1997 | 1 |
|---|---|
| 1998 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2009 | 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 ('2809007'))
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 ('2809007'))
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 WPR09LA211Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-8 · Phoenix, AZThe failure of ramp personnel and the flight crew to maintain clearance from ground equipment while taxiing. Contributing to the accident was the improper positioning of the ground equipment.NTSB DEN08LA055Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-202 · Denver, COThe encounter with severe turbulence causing serious injury to the flight attendant.NTSB DEN05IA084Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-202 · Denver, COThe improper procedures conducted by the ground personnel and the flight crew's failure to coordinate procedures with the ground personnel during push back operation which resulted in the collision between the ground support vehicle and the airplane. A…NTSB FTW98LA353Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Telluride, COThe inadequate chocks and inadequate chocking procedures by the operator. Factors were the unavailability of the parking brake and sloping terrain.NTSB MIA98LA017Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-8-201 · Jacksonville, FLThe passengers failure to secure her seatbelt as directed by the flight crew (seatbelt sign illuminated) on initial takeoff climb resulting in her ejection from her seat during an encounter with turbulence.