Skip to content

Wright C9HD series

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.engine_model_code IN ('67028') 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.engine_model_code IN ('67028')
  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.engine_model_code IN ('67028')
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 FTW05LA003Accident · Minor injuriesLimited investigationFinal reportLockheed 18-56 · Midland, TXThe pilot's failure to maintain directional control during takeoff. Contributing factors were the choice of runway used and the prevailing tailwind.Oct 3, 2004 · N6371C · Substantial damage NTSB LAX97LA122Accident · No injuriesLimited investigationFinal reportColumbia XJ-7 · Camp Pendelton, CAloss of engine power due to an undetermined cause or causes.Mar 13, 1997 · N48RW · Substantial damage NTSB MIA89FA096Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · Isla Verde, PRThe failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.Mar 1, 1989 · N28PR · Substantial damage NTSB MKC86FA179Accident · 2 fatalField investigationFinal reportLockheed 18-56 (Howard 250) · Texarkana, ARWhile apchg for a lndg, the acft pitched up, rolled inverted & impacted the terrain to the left of the rwy. No preimpactpart failure/malfunction was fnd; however, an inv revealed the acft had been loaded with the center-of-gravity (CG) wellbehind the aft…Aug 28, 1986 · N252K · Destroyed NTSB NYC84FA110Accident · 2 fatalField investigationFinal reportLockheed 18-56 · Oneonta, NYAt aprx 2330 EST, witnesses near the crash site heard an acft, & shortly thereafter, they saw a flash. One of them, who was driving a car, went back to the area the next day & found the acft wreckage. The acft had crashed & burned about 1 mi from the apch end…Mar 17, 1984 · N77777 · Destroyed NTSB ATL83FA237Accident · 2 fatalField investigationFinal reportLockheed L-18 · Millhaven, GAThe acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around…Jun 23, 1983 · N333FB · Destroyed NTSB ATL83FA021Accident · 3 fatalField investigationFinal reportLockheed 18 · Kosciusko, MSThe acft was observed without lights making repeated low altitude passes over a pipeline right-of-way at night. The acftwas equipped with an internal aux fuel tank, non-standard internal plumbing, a large lever-operated petroleum products pump, an inflatable…Oct 18, 1982 · N1040G · Destroyed NTSB LAX80DJA08Accident · Serious injuriesClosedLockheed 18 · Palmyra Island, HIJan 5, 1980 · N163R · Substantial damage NTSB MIA79FLA40Accident · No injuriesClosedLockheed 18 · Brunswick, GAJul 24, 1979 · N33LM · Substantial damage NTSB FTW79FRD27Accident · No injuriesClosedLockheed 18 · Melville, LAMay 7, 1979 · N513V · Substantial damage NTSB FTW77FA061Accident · Minor injuriesClosedLockheed L-18 · Austin, TXJun 10, 1977 · N333FB · Substantial damage NTSB OAK76DJY01Accident · No injuriesClosedLockheed L-18 · Puerto Princes, RPJul 4, 1975 · N100DK · Substantial damage NTSB MIA74FLD19Accident · No injuriesClosedLockheed L-18 · Lakeland, FLAug 20, 1973 · N608L · Substantial damage NTSB NYC72AN038Accident · Minor injuriesClosedLockheed PV-1 · Philadelphia, PASep 11, 1971 · N725YC · Destroyed NTSB LAX71AL002Accident · No injuriesClosedLockheed 18 · Phoenix, AZJul 5, 1970 · N34E · Substantial damage NTSB LAX67A0095Accident · 2 fatalClosedLockheed 18 · Aguila, AZApr 11, 1967 · N699C · Destroyed NTSB LAX67A0042Accident · No injuriesClosedLockheed 18 · Pacoima, CAOct 19, 1966 · N699C · Substantial damage

Back to Wright C9HD series