Final NTSB investigations: Lambert R266

8 cases on aircraft whose registry engine model is Lambert R266. 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

19642026

Final NTSB investigations: Lambert R266 per year, 1964–2026: 8 cases
1964	1
1966	1
1967	1
1970	1
1971	1
1995	2
2007	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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('38501')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('38501'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('38501'))
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 NYC07CA099Accident · Minor injuriesData collectionFinal reportMonocoupe 90A · Lakeland, FLThe pilot's improper flare and failure to maintain airspeed, which resulted in a stall and subsequent loss of control. A factor was the sun glare.Apr 19, 2007 · N11798 · Substantial damage NTSB LAX96LA056Accident · Minor injuriesLimited investigationFinal reportMonocoupe 90A · Salinas, CAthe pilot's failure to properly recover from a slipping maneuver.Nov 26, 1995 · N11768 · Substantial damage NTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.Jul 4, 1995 · N583Y · Substantial damage NTSB NYC72FKM05Accident · No injuriesClosedMonocoupe 90A · Monroe, NCSep 8, 1971 · N119V · Substantial damage NTSB IAD71DKM10Accident · No injuriesClosedMonocoupe 90A · Monroe, NCAug 22, 1970 · N119V · Substantial damage NTSB LAX67F0318Accident · No injuriesClosedMonocoupe 90A · Tucson, AZFeb 24, 1967 · N19438 · Substantial damage NTSB LAX66F0272Accident · No injuriesClosedMonocoupe 90 · Long Beach, CAFeb 27, 1966 · N520W · Substantial damage NTSB UNK65X0248Accident · 2 fatalClosedMonocoupe 90A · Watkins, COOct 11, 1964 · N18051 · Destroyed