NTSB investigations: Weatherly 201C, 1982
4 cases on aircraft the registry lists as Weatherly 201C. 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
| 1976 | 1 |
|---|---|
| 1978 | 5 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2007 | 1 |
| 2011 | 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630410'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630410'))
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 DEN82DA111Accident · No injuriesFinal reportWeatherly 201C · Near Rapelje, MTWhile landing on a county road, the pilot lost directional control and the aircraft veered to the left and struck a pole. An investigation revealed that an 0-ring, pn 101-00500, on the parking brake valve in the right master cylinder had failed and hydraulic…NTSB FTW82DA226Accident · No injuriesFinal reportWeatherly 201C · Lakewood, ARThe right main gear of the aircraft failed during the takeoff roll. The pilot stated that the gear failed after he had rolled about 150 ft.NTSB SEA82DA053Accident · No injuriesFinal reportWeatherly 201C · Espanola, WAThe pilot stated that during climb the engine power suddenly went to idle. A forced landing was made in a soft plowed field where the aircraft nosed over. No mechanical malfunctions were found during the engine examination however it was noted that conditions…NTSB SEA82FYM10Accident · No injuriesFinal reportWeatherly 201C · Wasco, ORThe pilot reported that during takeoff, the engine did not maintain full power. While landing in a residential area, the aircraft struck a telephone wire and three trees. An examination of the engine revealed no obvious defects that would cause a loss of…