Skip to content

Engineering & Research 415-D

NTSB investigations · 16

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 ('0420306') 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 ('0420306')
  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 ('0420306')
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 GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.Jul 23, 2016 · N2377H · Substantial damage NTSB ERA13LA406Accident · No injuriesLimited investigationFinal reportEngineering & Research 415-D · Beaver Falls, PAThe owner/pilot’s failure to follow engine manufacturer recommendations for engine oil changes and spark plug cleaning and rotating when operating the airplane with 100 low lead fuel, which resulted in carbon buildup in the engine and the total loss of engine…Sep 6, 2013 · N3940H · Substantial damage NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.Sep 27, 1991 · N99283 · Destroyed NTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.Aug 3, 1988 · N169WS · Substantial damage NTSB ATL87LA090Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Cottondale, ALThe plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction.Mar 22, 1987 · N99436 · Substantial damage NTSB NYC81FNE31Accident · No injuriesClosedErco 415-D · Danbury, CTSep 12, 1981 · N99436 · Substantial damage NTSB MIA77DKG06Accident · No injuriesClosedErco 415-D · St.Mary'S, GANov 8, 1976 · N94677 · Substantial damage NTSB OAK75AP053Accident · 2 fatalClosedErco 415-C · San Andreas, CAMay 28, 1975 · N87263 · Destroyed NTSB NYC75DNC11Accident · Minor injuriesClosedErco 415-D · Cambridge, MESep 29, 1974 · N1084 · Substantial damage NTSB IAD74DLQ36Accident · Minor injuriesClosedErco 415-C · Centertown, KYMay 29, 1974 · N3474H · Substantial damage NTSB NYC74DGT11Accident · No injuriesClosedErco 415-D · Hershey, PASep 30, 1973 · N3850H · Substantial damage NTSB LAX73DUJ76Accident · No injuriesClosedErco 415D · Lk Hvsu Cty, AZOct 14, 1972 · N3618H · Substantial damage NTSB LAX72FUQ09Accident · Serious injuriesClosedErco 415-D · Van Nuys, CAJul 24, 1971 · N3618H · Minor damage NTSB OAK67D0009Accident · No injuriesClosedErcoupe 415-C · S.Luis Obispo, CAMay 29, 1966 · N3618H · Substantial damage NTSB NYC66F0042Accident · No injuriesClosedErcoupe 415 · E Moriches, NYJun 20, 1965 · N99616 · Substantial damage NTSB UNK64X2050Accident · Minor injuriesClosedErcoupe 415C · Mukwonago, WIMay 31, 1964 · N2043H · Destroyed

Back to Engineering & Research 415-D