Final NTSB investigations: Walter M601 series
10 cases on aircraft whose registry engine model is Walter M601 series. 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
| 1998 | 2 |
|---|---|
| 2000 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2022 | 2 |
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.engine_model_code IN ('64002', '64003'))
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.engine_model_code IN ('64002', '64003'))
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 DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…NTSB CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.NTSB CEN10LA422Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · McCook, NEThe pilot's inadequate visual lookout during taxi, which resulted in a collision with a parked airplane.NTSB DFW05LA116Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fenton, LAThe loss of engine power due to fuel starvation as a result of blockage of the firewall fuel filter with an unknown contaminant. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL02LA099Accident · 1 fatalLimited investigationFinal reportAero Partners One CA 7SL · Merritt Island, FLThe pilot's inadequate in-flight planning/decision resulting in the misconfiguration of the flaps and the elevator trim setting. The misconfiguration resulted in an inadvertent pitch-up, loss of airspeed, stall and collision with the ground.NTSB SEA00LA073Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Acequia, IDThe pilot's failure to obtain/maintain adequate clearance with the irrigation system during initial climb. A contributing factor was the irrigation pivot.NTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.NTSB CHI98LA108Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Steele, MOthe pilot failed to maintain an adequate visual lookout. A factor was the pile of gravel in the taxiway.