NTSB investigations: Eagle EAGLE DW-1, 1984
6 cases on aircraft the registry lists as Eagle EAGLE DW-1. 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
| 1981 | 2 |
|---|---|
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 4 |
| 1993 | 3 |
| 1994 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3230203'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3230203'))
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 MKC84FA218Accident · 1 fatalField investigationFinal reportEagle DW1 · Kimball, NEThe acft collided with a microwave tower 158 ft AGL while the plt was making a smoke trail to test the wind. As the plt was seen to look back along his smoke path, the acft collided with the tower. The cables supporting the twr & the twr destroyed the acft…NTSB SEA84LA157Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Quincy, WAThe acft nosed over during landing. The plt said vibration caused the parking brake to be set in the 'on' position priorto landing. At about 20 mph he used the brakes and the acft nosed over.NTSB DEN84LA215Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Marion, SDIn cruise flt, oil covered the windscreen and plt elected a precautionary landing on a dirt road. Acft collided with a mailbox on roll out and nosed over. Oil filler cap found loose.NTSB CHI84LA254Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe plt reported that he had completed spraying 60 acres of land & was beginning a pass in another field. Half way through the spray pass the eng quit. He pulled up to clear a tree & the acft stalled into a field of sunflowers. No mechanical failure or…NTSB CHI84LA231Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe acft ran off a road into a ditch which destroyed the main landing gear during the forced landing. The plt said oil covered the windshield after takeoff and he could not see well enough to find the airstrip so he landed on the road while looking out the…NTSB SEA84LA098Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Spangle, WAAccording to FAA inspectors, the plt polished the lower leading edges of wings before departing, as they were covered with frost. The plt stated that during climb out the acft entered an inadvertent stall, followed by a three point landing onto soft field.…