NTSB investigations: Dehavilland DHC-6 TWIN OTTER, 1988
4 cases on aircraft the registry lists as Dehavilland DHC-6 TWIN OTTER. 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 4 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 4 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 2 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802606'))
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 year(c."eventDate") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802606'))
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 ANC89LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Homer, AKAfter landing, the plt was advised to taxi to the ramp via the south taxiway, since this was the only taxiway that had been snow plowed. Only about a 12 ft width of the 80 ft wide taxiway had been plowed. The cleared portion was on the outer edge of the…NTSB BFO88FA067Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Chantilly, VAThe pilot inadvertently misused the flaps, by failing to set the flaps to the proper setting. The flaps were set full down. This caused the aircraft to pitch up steeply after liftoff. Additionally, the flight control lock was probably installed during some…NTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…NTSB ATL88LA083Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Charlotte, NCDuring the final approach on the instrument landing system, the pilot descended below the glidepath. The aircraft collided with a tree and struck the ground short of the runway threshold.