NTSB investigations, MN
11 cases where the defining event was Landing gear not configured.
Cases per year
| 2012 | 1 |
|---|---|
| 2015 | 2 |
| 2017 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\" = 'MN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095')
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" = 'MN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '095') 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 WPR26LA316Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Bemidji, MNNTSB CEN26LA124Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Glencoe, MNThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision of the flight.NTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN25LA008Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Inguadona, MNThe pilot’s failure to properly configure the landing gear on the amphibious airplane before a water landing.NTSB CEN24LA109Accident · Minor injuriesClass 4 · LimitedFinal reportJavron PA-12 Replica · Inver Grove Heights, MNThe pilot’s failure to properly configure the landing gear on his amphibious airplane before landing on water.NTSB CEN23LA298Accident · No injuriesClass 4 · LimitedFinal reportMariner Unknown · Lino Lakes, MNThe pilot’s failure to retract the landing gear on the amphibious airplane before landing on water.NTSB CEN20CA164Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A185 · Anoka, MNThe pilot's inadvertent extension of the landing gear and his subsequent water landing with the wheels extended.NTSB CEN17LA212Accident · No injuriesLimited investigationFinal reportCessna 210F · Anoka, MNThe failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.NTSB GAA15CA222Accident · No injuriesData collectionFinal reportCessna A185F · Emily, MNThe pilot's failure to retract the landing gear, which resulted in a gear down water landing and a nose over.NTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.