Skip to content

NTSB investigations · 32

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 ('2422902') 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 ('2422902')
  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 ('2422902')
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 CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.Sep 11, 2019 · N24DR · Destroyed NTSB DCA12WA073Accident · No injuriesForeign investigationConvair 440 · Ciudad de Guatemala, GuatemalaMay 11, 2012 · N171FL · Substantial damage NTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.Sep 22, 2005 · N181FL · Minor damage NTSB DFW05LA029Accident · No injuriesLimited investigationFinal reportConvair 580 · McAllen, TXThe failure to activate the hydraulic pump which resulted in the pilot's inability to maintain directional control.Dec 4, 2004 · N161FL · Substantial damage NTSB ATL04LA153Accident · 1 fatalLimited investigationFinal reportConvair Div. of Gen. Dynamics 440 · Beef IslandThe in-flight fire on the number two engine, for undetermined reasons.Jul 12, 2004 · N4826C · Substantial damage NTSB MIA95RA162Accident · 2 fatalForeign investigationConvair CV-440 · La Ramona, Dominican RepublicJun 27, 1995 · N356SA NTSB MIA95WA088Accident · Minor injuriesForeign investigationConvair 440 · Cap Haitien, HaitiMar 18, 1995 · N137CA · Substantial damage NTSB FTW93FA185Accident · No injuriesField investigationFinal reportConvair 440 · Greenville, TXThe pilot-in-command's failure to follow the published emergency procedures. Factors were engine fire warning system activating for undetermined reasons, and the resultant ac power loss when that engine was secured. The lack of recent expereince in type…Jun 9, 1993 · N580HH · Substantial damage NTSB DEN89FA064Accident · Minor injuriesField investigationFinal reportConvair 580 · Buena Vista, COInadvertent deactivation of fuel to the left engine as the pilot was making a precautionary shutdown of the right engine, and his failure to follow the emergency checklist procedure. Related factors were: low gearbox oil pressure (at flight altitude), and…Jan 20, 1989 · N73160 · Substantial damage NTSB DEN88FA061Accident · Minor injuriesField investigationFinal reportConvair 580 · Durango, COAfter making an IFR approach, the pilot made a go-around because he was blinded by the reflection of the landing/taxi lights against the falling snow. The pilot landed the aircraft after the second approach. The pilot said he sensed the aircraft drifting to…Feb 3, 1988 · N5808 · Substantial damage NTSB DEN84FA045Accident · No injuriesField investigationFinal reportConvair 440 · Rock Springs, WYCombs airways, flt 709, collided with a snow bank during the landing roll at sweetwater county aprt. The capt reported that 'immediately after touchdown, the acft veered left, struck a snow bank, then veered to the right 180 deg coming to rest on the rwy…Dec 20, 1983 · N73162 · Substantial damage NTSB LAX83IA331Incident · No injuriesIncident investigationFinal reportConvair 440 · Point Mugu, CAAn engine fire erupted during the climb to cruise. Following an emergency landing it was determined that there was a loose primer line fitting at the carburetor in the area of the greatest fire damage.Jul 13, 1983 · N827AA · Minor damage NTSB DCA83AA013Accident · 1 fatalFinal reportConvair 580-11-A · Brainerd, MNDuring arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…Jan 10, 1983 · N8444H · Substantial damage NTSB LAX82DA042Accident · Minor injuriesFinal reportConvair 440 · Honolulu, HIAfter lift-off, the pilot called for the landing gear to be raised. As the plane was climbing through about 100 ft AGL, the pilot noted a loss of power in the right engine and saw a fire light. Ground witnesses heard a muffled explosion and saw smoke and fire…Jan 18, 1982 · N21DR · Destroyed NTSB ANC81FA059Accident · No injuriesClosedConvair 440 · Dillingham, AKJun 4, 1981 · N121CA · Destroyed NTSB MIA80RA013Accident · Serious injuriesClosedConvair 440 · Freeport, Burkina FasoNov 24, 1979 · N444JM · Substantial damage NTSB MKC80IA003Incident · No injuriesClosedConvair 580 · Thief Riv Fls, MNOct 31, 1979 · N4822C · Minor damage NTSB MKC79FA015Accident · No injuriesClosedConvair CV580 · St Louis, MOJan 19, 1979 · N73161 · Substantial damage NTSB DCA78AA019Accident · Serious injuriesClosedConvair 580 · Kalamazoo, MIJul 25, 1978 · N4825C · Substantial damage NTSB NYC78FA053Accident · No injuriesClosedConvair 440 · Shippingport, PAMay 12, 1978 · N9302 · Substantial damage NTSB NYC77FA040Accident · No injuriesClosedConvair 580 · Flushing, NYMar 18, 1977 · N5812 · Substantial damage NTSB NYC77FA023Accident · Serious injuriesClosedConvair 580 · Bradford, PADec 21, 1976 · N5811 · No damage NTSB MKC73IK072Incident · No injuriesClosedConvair 580 · Minneapolis, MNMay 31, 1973 · N968N · Minor damage NTSB DCA71AZ009Accident · 28 fatalClosedConvair 580 · New Haven, CTJun 7, 1971 · N5832 · Destroyed NTSB IAD70II066Incident · No injuriesClosedConvair 580 · Morgantown, WVJun 28, 1970 · N5826 · No damage NTSB CHI70IC047Incident · No injuriesClosedConvair 580 · Houghton, MIFeb 1, 1970 · N968N · Minor damage NTSB MIA69A0089Accident · Minor injuriesClosedConvair 440 · Macon, GAJun 10, 1969 · N4821C · Substantial damage NTSB DCA69A0011Accident · 11 fatalClosedConvair 440 · Bradford, PAJan 6, 1969 · N5825 · Destroyed NTSB DCA69A0010Accident · 27 fatalClosedConvair 580 · Chicago, ILDec 27, 1968 · N2045 · Destroyed NTSB MKC68A0073Accident · No injuriesClosedConvair 580 · Sioux Falls, SDJun 24, 1968 · N4824C · Substantial damage NTSB CHI67A0118Accident · No injuriesClosedConvair 440 · Milwaukee, WIApr 15, 1967 · N4821C · Substantial damage NTSB MIA66I0083Incident · No injuriesClosedConvair CV-440 · Mobile, ALJan 17, 1966 · N9314 · No damage

Back to Convair 440