NTSB investigations: Great Lakes 2T-1A-2, CA
20 cases on aircraft the registry lists as Great Lakes 2T-1A-2. 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.
Cases per year
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2005 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3910101'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3910101'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.NTSB WPR19LA114Accident · No injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1A-2 · San Diego, CAThe fracture of the aileron hinge strap due to fatigue crack propagation, which resulted in substantial damage to a wing rib aft of the spar at the outboard aileron cutout. Contributing to the accident was inadequate maintenance inspection.NTSB GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.NTSB LAX05LA173Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Sonoma, CAa partial loss of engine power, which resulted from the fuel servo leaking and generating an excessively rich fuel/air mixture. A factor was the owner's failure to comply with a service bulletin.NTSB LAX96FA075Accident · Serious injuriesField investigationFinal reportGreat Lakes 2T-1A-2 · Fillmore, CAfailure of the pilot to take proper remedial action to recover from an intentional spin.NTSB LAX89LA174Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Ramona, CAThe pilot of the other aircraft did not maintain an adequate visual lookout and collided with this Cessna that was parked in the runup area.NTSB LAX86LA340Accident · Serious injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Santa Paula, CAThe biplane crashed in mountainous terrain after a loss of power. The acft had been doing aerobatic maneuvers prior to the engine failure. The plt indicated that the engine quit at 7,500 ft MSL while in a descent. She relinquished the flt controls to the…NTSB LAX85LA295Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Angwin, CADuring a VFR cross country flt, wx conditions along the route induced the plt to divert to the Angwin arpt. After an overflt to obtain wind information from the wind sock, the plt said he entered the pattern and completed a normal approach and touchdown.…NTSB LAX84LA468Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Van Nuys, CADuring the third touch & go landing the certificated plt receiving dual instruction was at the controls when directional control was temporarily lost. The CFI in the front cockpit regained control. Shortly thereafter the plt under instruction applied heavy…NTSB LAX82FA361Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Arcata, CAThe plt & pax were on a cross-country from somewhere in the klamath, CA area to hayward, CA. Witnesses observed it flying southbound at 50 to 100 ft over the ocean's shore line. Reportedly, the acft made a sharp left turn toward land, then crashed on a…NTSB LAX80FUG03Accident · Minor injuriesClosedGreat Lakes 2T-1A · Elsinore, CANTSB OAK79DVD23Accident · No injuriesClosedGreat Lakes 2T-1A · Willits, CANTSB OAK78FVM42Accident · No injuriesClosedGreat Lakes 2T-1A · Santa Cruz, CANTSB LAX78DUQ30Accident · No injuriesClosedGreat Lakes 2T1A-2 · Simi Valley, CANTSB LAX78DVM14Accident · No injuriesClosedGR Lakes 2T-1A · Santa Maria, CANTSB LAX78FUQ11Accident · No injuriesClosedBeech B19 · Van Nuys, CANTSB OAK78DVD02Accident · No injuriesClosedGreat Lakes 2THA2 · Oakland, CANTSB UNK77X0103Accident · Serious injuriesClosedGreat Lakes 2T-1A2 · San Fernando, CANTSB OAK76DVG99Accident · No injuriesClosedGreat Lakes Baby · Chico, CANTSB LAX75FUQ27Accident · No injuriesClosedGR Lakes 2T-1A2 · Lancaster, CA