NTSB investigations · 16

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('242270A') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('242270A')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('242270A')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 DCA12FA051Accident · 2 fatalClass 1 · FieldFinal reportConvair 440 - NO Series · San Juan, PRthe flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.Mar 15, 2012 · N153JR · Destroyed NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…Dec 7, 2001 · N582HG · Substantial damage NTSB SEA96FA039Accident · Minor injuriesField investigationFinal reportConvair 340 · Spokane, WAthe pilot's improper management of the fuel/system, which resulted in loss of power in both engines, due to fuel starvation. Factors relating to the accident were: false indications of the cockpit fuel gauges, darkness, and the presence of a berm in the…Jan 5, 1996 · N358SA · Destroyed NTSB DEN84FA021Accident · Serious injuriesField investigationFinal reportConvair 580 · Sioux Falls, SDThe acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the…Nov 7, 1983 · N7517U · Minor damage NTSB DEN84FA008Accident · No injuriesField investigationFinal reportConvair 340/440 · Pierre, SDAfter landing at Pierre, SD, 2070 lbs of cargo was off-loaded from the aft section of the aft & a new wt & balance was calculated. The aircrew then prepared to takeoff in conditions of low ceiling & fog. The plt-in-command (PIC) initiated the takeoff roll,…Oct 20, 1983 · N199CF · Substantial damage NTSB ATL83IA028Incident · No injuriesIncident investigationFinal reportConvair 340 · Greenboro, NCThe pilot stated that while at cruise at 4000 feet that there was a sharp jolt in the airframe and on further investigation discovered that the left engine was on fire. The propeller stopped turning shortly thereafter. Immediately the pilot pulled the…Nov 11, 1982 · N4814C · Minor damage NTSB MKC78FA030Accident · No injuriesClosedConvair 340 · Elma, IAMar 21, 1978 · N4807C · Destroyed NTSB NYC73AN151Accident · Minor injuriesClosedConvair 580 · Pittsburgh, PAJun 12, 1973 · N5837 · Substantial damage NTSB IAD71II013Incident · No injuriesClosedConvair 580 · Wheeling, WVOct 20, 1970 · N5814 · Minor damage NTSB CHI70AC046Accident · Minor injuriesClosedConvair 580 · Detroit, MIFeb 1, 1970 · N2728R · Substantial damage NTSB DIA69A0005Accident · Minor injuriesClosedConvair 580 · Morgantown, WVJul 25, 1968 · N5817 · Substantial damage NTSB MIA68A0110Accident · No injuriesClosedConvair 340 · Memphis, TNJun 30, 1968 · N4813C · Substantial damage NTSB NYC67I0132Incident · No injuriesClosedConvair 580 · Atlantic City, NJMar 27, 1967 · N5814 · No damage NTSB MIA67A0080Accident · Minor injuriesClosedConvair 640 · San Juan, PRJan 23, 1967 · N3408 · Substantial damage NTSB MKC62A0046Accident · No injuriesClosedConvair 340 · Pierre, SDOct 24, 1962 · N90857 · Substantial damage NTSB NYC62A0108Accident · 1 fatalClosedConvair 340 · Windsor Lock, CTOct 19, 1962 · N8415H · Minor damage

Back to Convair 340