NTSB investigations, IN
32 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 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\" = 310)
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" = 310) 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 CHI07CA278Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Hagerstown, INThe pilot's use of an unsuitable runway for takeoff and delayed aborted takeoff. Factors were the wet grass and the fence the airplane impacted and subsequently nosed over.NTSB CHI07LA005Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Lake Village, INInadequate visual lookout by the pilot. A factor associated with the accident was that neither airplane was equipped with communications equipment.NTSB CHI06CA181Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Indianapolis, INThe failure of the tug driver to maintain clearance from the airplane taxiing on an active taxiway. A factor was the night conditions.NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.NTSB CHI03LA193Accident · No injuriesLimited investigationFinal reportCessna 172H · Plymouth, INThe collision with a deer during landing.NTSB CHI03IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-83N · Indianapolis, INThe ground tow personnel not maintaining clearance from the de-icing vehicle during the tow back to the gate. Factors were the de-icing vehicle that parked by the airplane's left wing, the ground personnel not following the operator's towing…NTSB CHI02LA264Accident · No injuriesLimited investigationFinal reportCessna 182S · Fishers, INThe pilot failed to maintain clearance with the light pole while taxiing. A factor was the light pole.NTSB CHI01LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jeffersonville, INThe airplane was struck by deer during landing roll at night. A factor was the dark night.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB CHI00LA183Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INthe failure of the pilot to maintain clearance from the building during taxi.NTSB CHI00LA047Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Indianapolis, INthe flight crew misjudged the clearance between their right wing and the radome of the parked aircraft. A factor associated with the accident was the ground handling contractor failed to identify the unsafe/hazardous condition that existed on the congested…NTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.NTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…NTSB CHI98LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkhart, INthe pilot's disorientation that led him to believe he was on the active runway. A factor was the pilot's inattentiveness.NTSB CHI96LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Wabash, INdeer that went onto the runway as the aircraft was landing. The light condition at dusk was a related factor.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).NTSB CHI94LA136Accident · No injuriesLimited investigationFinal reportCessna 150A · Angola, INthe on ground collision of the airplane with a deer. A factor was the dark night.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB CHI90FA075Accident · 1 fatalField investigationFinal reportBoeing 727 · Indianapolis, INThe tug operator's failure to maintain control of the tug, possibly due to having inadvertently placed or caught his built-up, steel-toe boot under the brake pedal.NTSB CHI89LA187Accident · No injuriesLimited investigationFinal reportCessna 120 · Shelbyville, INThe pilot failed to maintain proper alignment during the landing roll.NTSB CHI88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Marion, INThe pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover…NTSB CHI88LA071Accident · No injuriesLimited investigationFinal reportCessna 150M · Crane, INN66452, collided with a street signpost at the Crane naval depot, Crane, IN, during landing roll after a precautionary emergency landing. The right wing of the aircraft was substantially damaged. The student was on the return leg of a two-leg solo cross…NTSB CHI88LA013Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Leavenworth, INAccording to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…NTSB CHI87LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Winamac, INAfter noticing a vague shape off the right side of the aircraft, during takeoff run at night, the pilot continued down the runway until the aircraft collided with a 180 pound deer.NTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.NTSB CHI85LA068Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Lafayette, INWhile turning the prop by hand to lubricate the engine it unintentionally started and ran at aprx 1700 RPM. The acft was not chocked or tied down and the parking brake was not set. The acft traveled across the ramp and collided with an empty t-hangar. After…NTSB CHI84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, INThe plt was attempting a takeoff on a country road. He stated that during the takeoff he noticed the acft was not set-up for a short field takeoff so he decided to abort. During the takeoff abort the acft struck a tree alongside the road and the the acft…NTSB CHI83LA429Accident · No injuriesLimited investigationFinal reportCessna 150M · Anderson, INCessna 150, N45257, collided with Cessna 182, N2462G, at ace airpark. N45257 was in the process of landing and N2462G was in the takeoff phase of operation. Neither plt used the airport UNICOM. Both plts rept slightly different wx conditions.NTSB CHI83LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Boonville, INOn takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over.NTSB CHI83LA021Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Indianapolis, INThe left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.NTSB CHI82DA126Accident · No injuriesFinal reportRaven RX-6 · Sellersburg, INDuring a landing approach, the pilot was aware of powerlines to the left of his course. Just prior to touchdown, he became aware of a branch off of the powerlines that crossed in front of the balloon's path. He ripped out the top inflation panel; however,…