NTSB investigations, IN
11 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2006 | 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\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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" = 'IN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) 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 CHI06CA130Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Brook, INThe pilot's intentional decision to leave the helicopter unattended with the engines running which resulted in a dynamic rollover. The inadvertent dynamic rollover was a factor.NTSB CHI04CA102Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Lake Village, INThe unsuitable terrain the Certified Flight Instructor encountered during the off-field landing. The low altitude, the downdraft or "sink" experienced during flight, and the soft terrain conditions were factors to the accident.NTSB CHI00LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, INthe pilot's disregard of the unsafe runway condition, his decision to operate the airplane on unsuitable terrain, and the failure to maintain runway centerline alignment which resulted in the landing gear contacting deeper snow. Factors associated with the…NTSB CHI98LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Demotte, INThe pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.NTSB CHI96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Zionsville, INthe pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.NTSB CHI90LA088Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Gary, INFailure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…NTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.NTSB CHI87LA071Accident · No injuriesLimited investigationFinal reportCessna 152II · West Middleton, INDuring the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.NTSB CHI84LA129Accident · No injuriesLimited investigationFinal reportCessna 150M · Hagerstown, INDuring the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…NTSB CHI82DA133Accident · No injuriesFinal reportCessna 182 · Brazil, INThe pilot elected to land on the grass adjacent to a paved runway. While on landing roll the landing gear contacted the edge of a paved taxiway that ran perpendicular to the runway. The aircraft nosed over and came to rest inverted.