NTSB investigations: Weatherly 201B, CO
5 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
| 1976 | 1 |
|---|---|
| 1981 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 2000 | 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\" = 'CO' 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 ('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 c."eventStateOrRegion" = 'CO' 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 ('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 DEN00LA072Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Rocky Ford, COA total loss of power due to an engine rocker arm failure and soft/unsuitable terrain during the subsequent forced landing.NTSB DEN90LA147Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Center, COThe pilot's failure to maintain flying speed, which resulted in a stall and collsion with the ground.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 DEN81DTE62Accident · No injuriesClosedWeatherly 201B · Beulah, CONTSB DEN76AD030Accident · No injuriesClosedWeatherly 201B · Two Buttes, CO