Skip to content

NTSB investigations · 30

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 ('5500604') 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 ('5500604')
  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 ('5500604')
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 ATL07CA006Accident · No injuriesData collectionFinal reportMcCullough J-2 · Indian Trail, NCThe pilot's inadequate compensation for gusting wind conditions and his improper landing flare during an emergency landing after takeoff resulting in a hard landing.Oct 12, 2006 · N4362G · Substantial damage NTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.Oct 27, 2004 · N62SJ · Substantial damage NTSB LAX94LA246Accident · 1 fatalLimited investigationFinal reportMcCulloch J-2 · Willits, CAa loss of engine power for undetermined reasons.Jun 11, 1994 · N22GR · Destroyed NTSB SEA90LA012Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Scappoose, ORDelayed remedial action by the flight instructor and failure of the student to relinguish control. Factors include inadequate airspeed and an excessive descent rate.Nov 10, 1989 · N4379G · Substantial damage NTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.Jun 17, 1989 · N4354G · Destroyed NTSB CHI86LA232Accident · Serious injuriesLimited investigationFinal reportMcculloch J-2 · Rush City, MNJust after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the…Sep 26, 1986 · N90563 · Destroyed NTSB FTW86LQG17Accident · No injuriesFinal reportMcculloch J-2 · Stanton, TXPilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available.Jul 28, 1986 · N4319G · Destroyed NTSB NYC85LA154Accident · Minor injuriesLimited investigationFinal reportMcCulloch J-2 · Cortland, NYAccording to the pilot, the rotor blade contacted the tail rudders because of insufficient rotor speed. The rotor bladeswere thrown out of track and the gyroplane lost control. The insufficient rotor RPM was due to a rotor or pulley belt stripping.Jun 23, 1985 · N4328G · Substantial damage NTSB ATL85LA205Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Union City, TNPilot with 7900 total hours and four hours in gyoplane was on solo cross country training flight. During takeoff at enroute stop rotor blades struck vertical stabilizer. Pilots instructor said witnesses reported that the gyroplane was rotated abruptly during…Apr 21, 1985 · N4374G · Substantial damage NTSB CHI81FER38Accident · Minor injuriesClosedMcculloch J-2 · Owatonna, MNMay 21, 1981 · N18804 · Destroyed NTSB ATL81FID01Accident · Serious injuriesClosedMccullock J2 · Chesapeake, VAOct 3, 1980 · N4372G · Destroyed NTSB NYC78FHJ21Accident · Minor injuriesClosedMccolloch T-1 · South Haven, NYAug 27, 1978 · N4301G · Substantial damage NTSB CHI77FEC39Accident · No injuriesClosedMcculloch J-2 · Flint, MIJun 26, 1977 · N4328G · Substantial damage NTSB NYC76FFJ15Accident · No injuriesClosedMcculloch J-2 · Scottsville, NYJan 25, 1976 · N4331G · Substantial damage NTSB FTW75FPG24Accident · Serious injuriesClosedMccullough J-2 · Brinkley, AROct 12, 1974 · N4352G · Destroyed NTSB NYC74FNA30Accident · No injuriesClosedMcculloch J-2 · Taunton, MAJan 3, 1974 · N4343G · Substantial damage NTSB SEA74DYC15Accident · No injuriesClosedMcculloch J-2 · Redmond, ORSep 9, 1973 · N4327G · Substantial damage NTSB MIA73DKG60Accident · No injuriesClosedMcculloch J-2 · Statesboro, GAFeb 12, 1973 · N4345G · Substantial damage NTSB NYC72FHM49Accident · No injuriesClosedMccullough J-2 · Hillburn, NYMay 14, 1972 · N4323G · Substantial damage NTSB LAX72DUJ01Accident · No injuriesClosedMcculloch J-2 · Phoenix, AZApr 26, 1972 · N4302G · Substantial damage NTSB MIA72DKH27Accident · No injuriesClosedMccullough J-2 · Cumming, GAApr 10, 1972 · N4336G · Substantial damage NTSB OAK72DVA52Accident · No injuriesClosedMccullough J-2 · Porterville, CAFeb 18, 1972 · N4341G · Substantial damage NTSB CHI72FEI30Accident · No injuriesClosedMcculloch J-2 · Canton, OHFeb 8, 1972 · N4312G · Substantial damage NTSB NYC72DNA32Accident · No injuriesClosedMccullough J-2 · Newport, RIFeb 5, 1972 · N4314G · Substantial damage NTSB LAX72FUQ57Accident · No injuriesClosedMccullough J-2 · Van Nuys, CAJan 5, 1972 · N4306G · Destroyed NTSB CHI72FEC16Accident · No injuriesClosedMcculloch J-2 · Linden, MIOct 4, 1971 · N4317G · Destroyed NTSB CHI72FEM33Accident · Minor injuriesClosedMccullough J-2 · Greenville, MISep 20, 1971 · N4313G · Substantial damage NTSB LAX71FUD15Accident · No injuriesClosedMccullough J-2 · Compton, CAMay 5, 1971 · N4303G · Destroyed NTSB LAX71FUQ61Accident · No injuriesClosedMcculloch J2 · Lancaster, CAFeb 26, 1971 · N4304G · Substantial damage NTSB LAX71FUA48Accident · No injuriesClosedMcculloch J2 · Long Beach, CAFeb 22, 1971 · N4301G · Substantial damage

Back to Mcculloch J-2