Final NTSB investigations: Convair 600-240D
16 cases on aircraft the registry lists as Convair 600-240D. 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
| 1962 | 1 |
|---|---|
| 1964 | 1 |
| 1965 | 3 |
| 1966 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1978 | 2 |
| 1989 | 1 |
| 1991 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2422660'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2422660'))
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 FTW92FA025Accident · No injuriesField investigationFinal reportBeech B19 · Forth Worth, TXInadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…NTSB NYC89LA189Accident · Minor injuriesLimited investigationFinal reportConvair CV-600-240D · Augusta, METhe failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…NTSB CHI79DA016Accident · No injuriesClosedConvair 600 · Wilmington, OHNTSB CHI79DA001Incident · No injuriesClosedConvair CV-600 · Cleveland, OHNTSB DCA74AZ006Accident · 11 fatalClosedConvair 600 · Mena, ARNTSB FTW72AF074Accident · No injuriesClosedConvair 600 · Alexandria, LANTSB FTW72AF054Accident · No injuriesClosedConvair 600 · Beaumont, TXNTSB FTW71AF011Accident · Serious injuriesClosedConvair 600 · Lake Charles, LANTSB FTW70A0007Accident · No injuriesClosedConvair 600 · Houston, TXNTSB FTW67A0009Accident · No injuriesClosedConvair CV-600 · Harlingen, TXNTSB FTW66A0101Accident · No injuriesClosedConvair CV-240 · Ft Worth, TXNTSB FTW66A0044Accident · No injuriesClosedConvair CV-240 · College Sta., TXNTSB MIA66A0047Accident · No injuriesClosedConvair 240D · Tallahassee, FLNTSB FTW65A0069Accident · No injuriesClosedConvair CV-240 · Tulsa, OKNTSB UNK65X0158Incident · No injuriesClosedConvair 240 · Roswell, NMNTSB CHI62A0009Accident · No injuriesClosedDouglas DC-7 · Chicago, IL