Skip to content

NTSB investigations · 17

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 ('3951508') 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 ('3951508')
  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 ('3951508')
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 WPR23LA152Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Los Alamos, NMThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion and ground collision.Apr 5, 2023 · N444M · Substantial damage NTSB GAA16CA509Accident · Minor injuriesData collectionFinal reportGrumman G44 · Lakeport, CAThe pilot's failure to retract the landing gear, which resulted in a gear-down water landing and a nose over.Sep 17, 2016 · N111W · Substantial damage NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.Sep 17, 2009 · N86627 · Substantial damage NTSB LAX87LA174Accident · Serious injuriesLimited investigationFinal reportGrumman G-44A · Ventura, CADuring a local pleasure flight, the pilot had reduced power and descended to a lower altitude to take pictures of a sailboat race. At approximately 200 feet the pilot made a descending right turn, then leveled off. The aircraft stalled and the pilot lowered…Apr 12, 1987 · N32BB · Destroyed NTSB ANC83FA137Accident · 1 fatalField investigationFinal reportGrumman G-44A · Big Lake, AKThe acft crashed in a level, wooded area. The initial impact with trees occurred aprx 40 ft AGL. Both wing tips & a portion of the left stabilizer & elevator were found at the bases of the trees that were first impacted. From the first impact point, the…Jul 31, 1983 · N1423 · Destroyed NTSB SEA79FAMS5Accident · 4 fatalClosedGrumman TYPE30 · Missing AircraftMay 27, 1979 · N4451 · Destroyed NTSB SEA79FA047Accident · 4 fatalClosedGrumman SCAN30 · Skykomish, WAMay 27, 1979 · N4451 · Destroyed NTSB DEN79FTM13Accident · No injuriesClosedGrumman G44A · Delta, UTMar 30, 1979 · N111W · Substantial damage NTSB ANC79DA015Accident · 3 fatalClosedGrumman G-44A · Cordova, AKOct 31, 1978 · N444W · Destroyed NTSB ANC73AA051Accident · Serious injuriesClosedGrumman G-44A · Dillingham, AKJun 4, 1973 · N9312R · Substantial damage NTSB MIA73FLD35Accident · No injuriesClosedGrumman G44A · Melbourne, FLNov 10, 1972 · N41988 · Substantial damage NTSB FTW70DRD26Accident · No injuriesClosedGrumman G-44 · New Orleans, LAMay 9, 1970 · N3377 · Substantial damage NTSB FTW69F0319Accident · Serious injuriesClosedGrumman G-44 · Lutcher, LADec 27, 1968 · N111W · Substantial damage NTSB ANC68I0048Incident · No injuriesClosedGrumman G-44A · Anchorage, AKMay 27, 1968 · N1423 · Minor damage NTSB FTW68A0096Accident · 1 fatalClosedGrumman G-44A · Lafitte, LAMay 24, 1968 · N41982 · Destroyed NTSB NYC68A0041Accident · No injuriesClosedGrumman G-44A · Alexandria Bay, NYSep 3, 1967 · N41988 · Substantial damage NTSB FTW65F0006Accident · Serious injuriesClosedGrumman G-44A · Abbeville, LAApr 16, 1965 · N86627 · Minor damage

Back to Grumman G-44A