Final NTSB investigations: Convair 340-31
15 cases on aircraft the registry lists as Convair 340-31. 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 | 3 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 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 ('2422804'))
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 ('2422804'))
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 FTW87FA080Accident · No injuriesField investigationFinal reportConvair CV-580 · Dallas, TXMetro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair…NTSB DEN86FA120Accident · Serious injuriesField investigationFinal reportConvair 580 · Denver, CON73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…NTSB FTW82FA018Accident · No injuriesClosedConvair 580 · Longview, TXNTSB DEN78IA009Incident · No injuriesClosedConvair 540 · Denver, CONTSB DEN74AD033Accident · Serious injuriesClosedConvair 580 · Cheyenne, WYNTSB DEN73AD028Accident · Serious injuriesClosedConvair 580 · Alamosa, CONTSB DEN71ID033Incident · No injuriesClosedConvair 580 · Albuquerque, NMNTSB LAX69A0027Accident · No injuriesClosedConvair 580 · Santa Barbara, CANTSB MKC69I0003Incident · Minor injuriesClosedConvair 580 · Pawnee City, NENTSB DEN68A0017Accident · No injuriesClosedConvair 580 · Denver, CONTSB DEN67I0036Incident · No injuriesClosedConvair 580 · Salt Lake City, UTNTSB UNK65X0437Accident · Minor injuriesClosedConvair CV-340 · Rock Springs, WYNTSB UNK64X3979Accident · No injuriesClosedConvair CV-440 · Farmington, NMNTSB UNK64X1647Incident · No injuriesClosedConvair 340 · Salt Lake City, UTNTSB MKC62A0052Accident · Serious injuriesClosedConvair 340 · Grand Island, NE