NTSB investigations: Eagle EAGLE DW-1, WA
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 | 1 |
|---|---|
| 1984 | 2 |
| 1988 | 1 |
| 2007 | 1 |
| 2010 | 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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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 WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.NTSB SEA07CA226Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Waterville, WAThe loss of engine power during takeoff for an undetermined reason. A contributing factor was the high vegetation in the field where the airplane came to rest.NTSB SEA88LA180Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Wenatchee, WAAfter takeoff, plt noted wind increasing. Plt then made downwind 300 ft AGL survey run of field to be sprayed abutting columbia river. In procedure turn over river at completion of run, acft encountered 'sinkhole' wihch plt could not counter with full power…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 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.…NTSB SEA81DYP40Accident · No injuriesClosedEagle DW-1 · Chelan, WA