Skip to content

NTSB investigations: Great Lakes 2T-1A

16 cases on aircraft the registry lists as Great Lakes 2T-1A. 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

19652026

Where

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 ('3910106')) 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 ('3910106'))
  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 ('3910106'))
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 CEN20CA238Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · Cambridge, OHThe pilot’s failure to maintain directional control during landing, which resulted in the airplane exiting the runway and striking a ditch.Jun 20, 2020 · N856L · Substantial damage NTSB ERA20CA210Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · St. Mary's, PAThe pilot's failure to maintain proper glide path during final approach which resulted in a collision with airport equipment short of the runway.Jun 8, 2020 · N863K · Substantial damage NTSB WPR12CA007Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A · San Diego, CAThe pilot's excessive brake application during landing.Oct 13, 2011 · N502GL · Substantial damage NTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.Nov 13, 2004 · N502GL · Substantial damage NTSB LAX02LA080Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-1 · San Diego, CAThe pilot failed to maintain directional control after encountering a gust of wind during the landing roll. Factors were the unexpected wind gusts and the soft terrain adjacent to the runway.Feb 9, 2002 · N502GL · Substantial damage NTSB DEN87FA216Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A · Bozeman, MT74-Year-OLD plt was performing aerobatics at small arpt for local tv news station to promote weekend airshow. Plt made right & left pass, each pass consisting of shallow descent, pullup from aprx 150 to 200 ft AGL, & slow roll. Plt began third pass from…Aug 13, 1987 · N313Y · Destroyed NTSB FTW87LA144Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lago Vista, TXWhile maneuvering at approximately 50 feet AGL, the aircraft's landing gear contacted a 7200 volt powerline. Control of the aircraft was lost, and it descended out of control into about 2 feet of water, causing substantial damage.Jun 14, 1987 · N874K · Substantial damage NTSB OAK77DVD26Accident · No injuriesClosedGreat Lakes 2T1A · Sonoma, CAMar 19, 1977 · N844K · Substantial damage NTSB LAX75FUM03Accident · Minor injuriesClosedGR Lakes 2T-1A · Holtville, CAAug 10, 1974 · N502GL · Substantial damage NTSB MIA73FKW01Accident · No injuriesClosedGreat Lakes 2T-1A · Chattanooga, TNJul 9, 1972 · N828K · Substantial damage NTSB OAK69A0057Accident · 1 fatalClosedGR Lakes 2T-1A · Modesto, CAMar 9, 1969 · N380H · Destroyed NTSB NYC68F0499Accident · 1 fatalClosedGR Lakes 2T-1A · Johnsville, PAMay 14, 1968 · N315Y · Destroyed NTSB FTW67F0326Accident · Minor injuriesClosedGreat Lakes 2T-1A · Smithville, TXOct 8, 1966 · N909N · Substantial damage NTSB LAX66F0165Accident · Serious injuriesClosedGreat Lakes 2T-1A · Tehachapi, CANov 9, 1965 · N11324 · Destroyed NTSB SEA66F0136Accident · No injuriesClosedGreat Lakes 2T-1E · Spokane, WASep 30, 1965 · N11333 · Substantial damage NTSB MIA66F0147Accident · No injuriesClosedGreat Lakes 2T1A · Jonesboro, GAJun 26, 1965 · N828K · Substantial damage