Skip to content

NTSB investigations · 21

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 ('3951802') 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 ('3951802')
  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 ('3951802')
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 DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…Dec 19, 2005 · N2969 · Destroyed NTSB MIA02WA063Accident · No injuriesForeign investigationGrumman G-73T · Paradise Island, BahamasFeb 16, 2002 · N130FB · Substantial damage NTSB MIA98IA001Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLthe partial failure of a component of the hydraulic system resulting in the collapse of the nose landing gear during the landing roll.Oct 1, 1997 · N168WS · Minor damage NTSB MIA94FA097Accident · 2 fatalField investigationFinal reportGrumman G-73T · Key West, FLFailure of the pilot-in-command to assure the bilges were adequately pumped free of water (adequately preflighted), which resulted in the aft center of gravity limit to be exceeded, and failure of the aircrew to follow the checklist. A factor related to the…Mar 18, 1994 · N150FB · Destroyed NTSB MIA87WA225Incident · No injuriesForeign investigationGrumman G-73-T · Bimini, BahamasAug 14, 1987 · N2969 · No damage NTSB MIA87FA013Accident · 1 fatalField investigationFinal reportGrumman G-73 · St. CroixThe plts lost aileron control shortly after takeoff while in a left turn. The left turning tendencies of the acft could not be corrected and the acft crash landed in the carribean sea. Post crash inspection of the acft revealed the left aileron control cable…Oct 28, 1986 · N604SS · Substantial damage NTSB MIA85IA155Incident · Minor injuriesIncident investigationFinal reportGrumman G-73-T · St. CroixWhile on an FAA observed proving flight, water take off, the left propeller electrical terminal failed. The part then penetrated the left forward passenger window and struck the FAA observer causing minor injury. The plastic part failed in over load due to…Apr 24, 1985 · N632SS · Minor damage NTSB MIA84IA147Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Ft. Lauderdale, FLAfter 2 unsuccessful attempts to 'ramp' the acft, plt took off again and flew to Ft. Lauderdale. Fly-by disclosed no nose landing wheel was present. Plt made landing on hard surface rwy. Metallurgical examination disclosed, nose gear strut assembly failed due…Apr 17, 1984 · N2969 · Minor damage NTSB MIA84IA077Incident · No injuriesIncident investigationFinal reportGrumman G-73 · West Palm Beach, FLThe acft experienced an elevator trim loss, encountered extreme 'shaking and vibration' of control column and tail section fluttering while on descent to Palm Beach int'l arpt. Investigation revealed that the end of the actuator shaft failed at a rivet hole…Feb 10, 1984 · N2969 · No damage NTSB LAX79FA024Accident · Minor injuriesClosedGrumman G73 · Catlina, CAJan 14, 1979 · N95DF · Destroyed NTSB MIA76OM002Accident · No injuriesClosedGrumman G-73 · Bimini, Burkina FasoJul 12, 1975 · N3010 · Substantial damage NTSB MIA75AM039Accident · No injuriesClosedGrumman G-73 · Miami, FLDec 26, 1974 · N7306 · Substantial damage NTSB ANC74AA034Accident · 4 fatalClosedGrumman G-73 · Missing AircraftSep 30, 1974 · N2965 · Destroyed NTSB MIA73FKT94Accident · No injuriesClosedGrumman G-73 · Miami, FLMay 7, 1973 · N7306 · Substantial damage NTSB LAX67A0110Accident · 1 fatalClosedGrumman G-73 · Avalon, CAMay 27, 1967 · N2968 · Destroyed NTSB MKC67A0064Accident · Serious injuriesClosedGrumman G-73 · Huron, SDMay 3, 1967 · N298GB · Substantial damage NTSB NYC67A0156Accident · No injuriesClosedGrumman G-73 · Ossining, NYApr 11, 1967 · N2964 · Substantial damage NTSB ANC66A0024Accident · No injuriesClosedGrumman G-73 · Bethel, AKDec 20, 1965 · N1208 · Substantial damage NTSB ANC65I0030Incident · No injuriesClosedGrumman G-73 · Bethel, AKDec 4, 1964 · N1208 · Minor damage NTSB UNK64X0993Accident · No injuriesClosedGrumman G73 · West Palm Bc, FLMar 20, 1964 · N2954 · Substantial damage NTSB UNK64X0992Accident · No injuriesClosedGrumman G73 · W Palm Beach, FLMar 20, 1964 · N2954 · Substantial damage

Back to Grumman G-73