NTSB investigations: Weatherly 620
10 cases on aircraft the registry lists as Weatherly 620. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2013 | 1 |
| 2017 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630602'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630602'))
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 ERA17CA251Accident · No injuriesData collectionFinal reportWeatherly 620 · Pemberton Twp, NJAn in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.NTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.NTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.NTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.NTSB LAX92LA350Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Stockton, CAThe pilot's poor inflight planning and visual lookout.NTSB SEA88LA148Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Wilbur, WAThe pilot reported that an engine power loss occurred during an aerial application maneuver. The pilot made a forced landing in rough terrain. Examination of the engine revealed deteriorated seals in the engine driven fuel pump. Exam of the electric fuel pump…NTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.NTSB DEN87LA116Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Greeley, COThe plt departed with full fuel in the acft to practice aerial spraying techniques. After 45 mins of practice he returned to the arpt for landing. He said that prior to entering the traffic pattern he switched from the half-full right tank to the full left…NTSB LAX84FUJ04Accident · 1 fatalFinal reportWeatherly 620 · Waddell, AZThe acft collided with a power line during a spray operation. Witnesses said the acft flew under a power line and as it pulled up collided with a line which angled off of the main line. The vertical stabilizer and part of the rudder separated. The acft nosed…NTSB FTW83LA243Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Cornerstone, ARThe acft collided with a dirt bank during a forced landing after the engine quit. The plt said he was making a swath runwhen the engine quit. The flagman said he saw black smoke then white smoke as the engine quit. Post crash investigation revealed that the…