Final NTSB investigations: Dehavilland DHC-8-102
7 cases on aircraft the registry lists as Dehavilland DHC-8-102. 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
| 1986 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2014 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2809003'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2809003'))
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 DCA14CA147Accident · No injuriesData collectionFinal reportDehavilland DHC 8 102 · Harrisburg, PAthe airplanes collision with geese during the takeoff roll.NTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…NTSB CHI97IA075Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Charleston, WVa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…NTSB CHI93IA068Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Detroit, MIThe manufacturer's inadequate design of the fuel transfer tube system, which loosened/disconnected during engine operation.NTSB ATL91IA134Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Savannah, GAThe inadequate inspection procedures which allowed the loss of torque on the top retraction fitting attachment bolt which subsequently failed in fatigue. Factors were the loss of hydraulic fluid through a severed line, and the corrosion of a hydraulic…NTSB MIA90IA159Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-100 · Panama City, FLFailure of seal in the hydraulic actuator for the right outboard wing spoiler panel for unknown reasons.NTSB ATL87IA034Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Atlanta, GAAt about 4,000 ft MSL, cpt on sch dom flt reported loud pop and sub shutdown of rt eng. Smell of smoke and visual confirmation of fire in rt nacelle. Ships fire ext activated during return to dept. Arpt. Landed without further incident. Investigation revld…