NTSB investigations: Berkshire Mfg. CONCEPT 70

8 cases on aircraft the registry lists as Berkshire Mfg. CONCEPT 70. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19722026

NTSB investigations: Berkshire Mfg. CONCEPT 70 per year, 1972–2026: 8 cases
1972	1
1973	1
1975	2
1983	1
1992	1
1993	1
1996	1

Where

Open the map

Latest cases

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1240104')) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1240104'))
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1240104'))
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 MIA96LA080Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLan engine loss of power and fire for undetermined reasons.Feb 20, 1996 · N29BW · Destroyed NTSB MIA93LA150Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLThe pilot's improper in-flight planning and the lack of adequate thermal lift.Jul 4, 1993 · N29BW · Substantial damage NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.Jul 12, 1992 · N382W · Substantial damage NTSB NYC83LA197Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Fairfield, PADuring the apch, the plt encountered unfavorable wind conditions & the glider touched down long. In order to avoid an embankment beyond the end of the strip, the plt turned toward a parallel rwy overrun area. Subsequently, the left wing hit two 55 gal drums…Jul 28, 1983 · N6BM · Substantial damage NTSB DEN76FTM07Accident · Minor injuriesClosedBerkshire 70 · Heber City, UTSep 20, 1975 · N4KX · Destroyed NTSB MIA7LDKG11Accident · No injuriesClosedBerkshire C70 · Cordele, GAAug 19, 1975 · N29BW · Substantial damage NTSB DEN73AD053Accident · 1 fatalClosedBerkshire C-70 · Burns, WYJun 10, 1973 · N10QT · Destroyed NTSB OAK73FXQ04Accident · Minor injuriesClosedConcept 70 · Minden, NVJul 19, 1972 · N44CW · Destroyed