NTSB investigations: Weatherly 620B, 1999
6 cases on aircraft the registry lists as Weatherly 620B. 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
| 1993 | 1 |
|---|---|
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1999 | 6 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 2 |
| 2025 | 2 |
| 2026 | 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\") = 1999
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630605', '9630607'))
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") = 1999
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630605', '9630607'))
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 FTW99LA251Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Big Spring, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.NTSB CHI99LA214Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Timber Lake, SDthe pilots selection of the shorter runway and his failure to abort the takeoff. Factors to the accident were the high density altitude, the fence and the fence posts.NTSB SEA99LA089Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Tetonia, IDA failure of the right magneto drive gear shaft. Factors include the absence of any suitable terrain on which to perform an emergency landing, and the rough/uneven condition of the terrain on which the pilot was forced to land.NTSB FTW99LA149Accident · Serious injuriesLimited investigationFinal reportWeatherly 620B · Whiteface, TXThe pilot's selection of unsuitable terrain for takeoff. Contributing to the accident was the soft ground and the standing water on the runway.NTSB LAX99LA107Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Yuma, AZThe pilot's failure to maintain an adequate clearance from the power lines during an aerial application flight. A factor in the accident was the dark night lighting conditions.