NTSB investigations: Weatherly 201B, 1984
3 cases on aircraft the registry lists as Weatherly 201B. 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
| 1972 | 1 |
|---|---|
| 1974 | 3 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 4 |
| 1978 | 5 |
| 1979 | 3 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2008 | 2 |
| 2015 | 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 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 ('9630408'))
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 ('9630408'))
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 DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…NTSB DEN84LA170Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Platteville, COThe ag plt was returning for his 3rd load. He said that after a wheel landing, he pulled back on the stick to lower the tailwheel & the acft ballooned back into the air. The plt said that he applied power to go around, but the acft settled & he lost…NTSB DEN84LA094Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Townsend, MTThe acft engine lost power on the base leg when the plt retarded the throttle. The plt landed on the rwy, but the acft started to veer to the right. The plt said he applied the brakes which did not seem to operate. Later, he said he may have had his feet on…