NTSB investigations, MO
87 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 5 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 'MO' 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\" = 220)
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" = 'MO' 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" = 220) 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 CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.NTSB CHI07CA244Accident · Minor injuriesData collectionFinal reportBell 206B · Columbia, MOThe pilot's failure to maintain control of the helicopter, which resulted in impact with terrain during takeoff. A factor in the accident was the tall grass.NTSB CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.NTSB CHI06LA244Accident · Minor injuriesLimited investigationFinal reportFairchild SA227-AC · Grain Valley, MOthe pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.NTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.NTSB CHI06FA094Accident · 4 fatalField investigationFinal reportPiper PA34-200T · Branson, MOThe pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…NTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.NTSB CHI05LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Kansas City, MOThe pilot not maintaining climb airspeed leading to the airplane's impact with the fence and terrain during takeoff. Factors in the accident were the pilot's inaccurate preflight planning calculations, the fence, and the levee.NTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.NTSB CHI05FA017Accident · 2 fatalField investigationFinal reportCessna 182J · Springfield, MOThe pilot's failure to maintain a proper altitude and his failure to maintain obstacle clearance while turning to reverse direction on final approach. A factor associated with the accident was the night lighting conditions which existed at the time of the…NTSB DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…NTSB CHI04CA288Accident · No injuriesData collectionFinal reportAeronca 7BCM · St. James, MOThe pilot's failure to maintain clearance from trees during the go-around. Factors were the sun glare and the trees.NTSB CHI04LA212Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Chesterfield, MOThe pilot's inadequate preflight planning due to his selection of an unsuitable takeoff area and his failure to maintain clearance from the open hangar door. A contributing factor was the open hangar door.NTSB CHI03LA182Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Dexter, MOThe pilot's inadequate visual lookout and failure to maintain clearance from the wires during the aerial application flight. Factors contributing to the accident were the helicopter's low altitude and the transmission wires.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…NTSB CHI01LA183Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Catron, MOthe failure of the pilot to maintain clearance from the electrical wires.NTSB CHI01LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Raymore, MOThe pilot failed to see and avoid the guy wires associated with a lighted tower. A factor associated with the accident was the guy wire.NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…NTSB CHI00LA104Accident · Minor injuriesLimited investigationFinal reportWilson RAF 2000 GTX SE · Monroe City, MOthe pilot not obtaining clearance from the trees. Factors were the trees and the ravine terrain condition.NTSB CHI00LA097Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Joplin, MOan inadequate rate of climb and the failure to attain clearance with the trees during the aborted landing. Factors associated with the accident were the pilot's failure to attain a proper touchdown point during the landing, the trees which were contacted, and…NTSB CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.NTSB CHI99GA155Accident · 2 fatalFinal reportBell OH-58A · Poplar Bluff, MOThe tail rotor's impact with the blue warm-up jacket and the subsequent overload of the tail rotor drive shaft. A contributing factor was the absence of the helicopter's entry doors.NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB CHI99FA102Accident · No injuriesField investigationFinal reportDouglas DC-9-15F · Kansas City, MOingestion of birds into both engines, resulting in foreign object damage and the subsequent partial power loss to both engines. A factor relating to this accident was the dark night.NTSB CHI98LA239Accident · Minor injuriesLimited investigationFinal reportRobinson R-44 · Cassville, MOThe pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.NTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.NTSB CHI98LA126Accident · 1 fatalLimited investigationFinal reportCessna 177 · Ft. Leonardwood, MOThe pilot's failure to maintain adequate obstacle clearance and his inadequate inflight decision which resulted in VFR flight in to instrument meteorological conditions. The pilot's overconfidence in his ability is a contributing factor.NTSB CHI97LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Lee'S Summit, MOthe pilot's inadequate preflight planning/preparation, and his failure to ensure that the airplane remained clear of obstrictions (trees). Factors associated with the accident were: the short runway/takeoff area, and the proximity of trees.NTSB CHI97LA207Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Columbia, MOthe pilot's failure to properly judge the landing approach. The proximity of transmission wires was a related factor.NTSB CHI97LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-25 · Sullivan, MOthe pilot's continued VFR flight into instrument meteorological conditions in an airplane not equipped for flight into IMC. Factors were: the pilot's inadequate preflight preparation, his inadequate evaluation of the weather, and fog.NTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.NTSB CHI96LA294Accident · Serious injuriesLimited investigationFinal reportCameron CIGPACK-80 · Columbia, MOfailure of the pilot to see-and-avoid transmission (power) lines during the landing. Factors relating to the accident were: vegetation and trees, which obscured the pilot's view of the power lines.NTSB CHI96FA141Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Buffalo, MOfailure of company/operator personnel to install the wing and landing gear (strut) fairings after modifying the airplane for a supplemental type certificate (STC), and improper planning/decision by the pilot. Factors relating to the accident were: the…NTSB CHI96LA130Accident · 3 fatalLimited investigationFinal reportCessna 177B · Perry, MOthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain altitude/clearance from the power transmission wires. Darkness, restricting the pilot's ability to see-and-avoid the transmission line, was a related factor.NTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.NTSB CHI94DCG02Accident · 1 fatalFinal reportAero Commander Calair A-9B · Excelsior Sprgs, MOThe pilot's failure to maintain altitude clearance above the powerlines during his maintenance test application run.NTSB CHI94FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Marshfield, MOFailure of the pilot to maintain proper altitude during a VFR flight into IMC conditions.NTSB CHI94LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Edina, MOthe pilot in commands' failure to obtain obstruction clearance from trees during a visual takeoff from a short, soft, wet field in instrument meteorological conditions. A factor was the pilot in commands' misjudgment of the takeoff climb performance of the…NTSB CHI94LA130Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Chesterfield, MOFailure of the pilot to follow proper IFR procedures and maintain proper altitude during the approach. Factors related to the accident were: darkness, the weather conditions, and failure of the approach controller to issue an IFR transponder code to the…NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.NTSB CHI93LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · California, MOThe pilot in command's failure to maintain adequate airspeed.NTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.NTSB CHI92FA232Accident · 2 fatalField investigationFinal reportBell 206B · St. Charles, MOThe pilot-in-command's failure to see and avoid the wires, and his physical impairment due to alcohol consumption. A factor which contributed to the effect of the alcohol impairment was the medicine.NTSB CHI92FA211Accident · 2 fatalField investigationFinal reportStinson 108-3 · Boonville, MOInadequate preflight planning, and exceeding the performance capability of the airplane by the pilot-in-command.NTSB CHI92DCA03Accident · 1 fatalFinal reportPiper PA-28-180 · Mokane, MOAn inadequate visual lookout by the pilot and his failure to maintain clearance from the wires.NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB CHI91FA294Accident · 3 fatalField investigationFinal reportBell-K Copter 47D1 · Laurie, MOPoor judgement of the pilot, due to impairment from consumption of alcoholic beverage before flight, his intentional buzzing, and his inadequate visual lookout (failure to see-and-avoid power lines).NTSB CHI91LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Cabool, MOFailure of the pilot to maintain proper runway alignment during a go-around. Factors related to the accident were: darkness and the pilot's lack of understanding of the landing gear electrical system.