NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
Cases, newest first
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.\"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."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 SEA89LA170Accident · No injuriesLimited investigationFinal reportHughes 369D · Petersburg, AKThe pilot failed to obtain clearance over trees. Contributing to the accident was: the aircraft being above its maximum certificated gross weight limitation and the trees.NTSB DCA89IA071Incident · No injuriesClass 1 · IncidentFinal reportBoeing 737-200A · Kansas City, MOThe flightcrew's failure to adequately prepare for and execute a nonprecision approach and their subsequent premature descent below minimum descent altitude. Contributing to the cause of the incident was the inadequate and deficient services provided to the…NTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.NTSB NYC89LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly · Hatboro, PAImproper in-flight planning/decision by the pilot which resulted in his failure to maintain clearance obstructions. A related factor was: the low level of propane (fuel), which resulted in low burner pressure.NTSB NYC89LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Wolfeboro, NHInadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…NTSB LAX89FA294Accident · 1 fatalField investigationFinal reportBeech V35TC · Fort Jones, CAThe failure of the pilot to maintain sufficient altitude.NTSB CHI89LA178Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Brooklyn, MIFailure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.NTSB BFO89FA075Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · Lynchburg, VAPilot's failure to maintain clearance from obstructions because of improper IFR operation. Contributing to the accident was descent below decision height, delay in initiating the missed approach, and fog conditions.NTSB DEN89FA200Accident · Serious injuriesField investigationFinal reportCessna 172 · Tremonton, UTThe pilot failed to maintain obstruction clearance while making a low pass over a newly constructed highway. The powerline was considered a contributing factor.NTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.NTSB MKC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Park Rapids, MNThe pilot misjudged the clearance between the helicopter and the power line. The power line (transmission wire) was considered to be a contributing factor.NTSB LAX89LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Williams, AZFailure of the pilot to maintain his visual lookout and flying low. Contributing to the accident was the one inch diameter telephone cable.NTSB CHI89DEI03Accident · Minor injuriesFinal reportBrumbaugh/Hubin Long EZE · West Salem, OHInadequate visual outlook and attention diversion by the pilot. Factor(s) related to the accident was: the presence of the wires.NTSB FTW89IA152Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Kenner, LAInaccurate operators procedures/directives and the improper takeoff performance data computed by the captain. Poor flight crew coordination was considered a factor as well a wrong runway selection for the computed takeoff data.NTSB LAX89FA275Accident · 4 fatalField investigationFinal reportMooney M20F · Livermore, CAThe pilot's decision to conduct low level night flight under low ceilings. Contributing factors were: the dark night, low ceiling, and high obstructions.NTSB NYC89LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-32 · Plymouth, CTImproper compensation for wind conditions by the pilot. A factor related to the accidetn was: the downdraft.NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).NTSB NYC89FA190Accident · 1 fatalField investigationFinal reportCessna 182Q · Edison Twshp, NJFailure of the pilot to follow the IFR procedure and maintain the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: minimum safe altitude warning (msaw) radar not enabled, and failure of the approach…NTSB FTW89DRG09Incident · No injuriesFinal reportMccormick Bushby Mustang II · Spicewood, TXThe pilot's failure to maintain proper clearance from personnel on the ground.NTSB FTW89LA147Accident · No injuriesLimited investigationFinal reportMooney M20K · Marietta, OKThe pilot's delay in aborting the landing (going around) and his improper raising of the flaps at an inadequate airspeed.NTSB ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.NTSB MKC89LA175Accident · Minor injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Indianola, IAFailure of the pilot to maintain clearance from the tv tower due to improper in-flight planning/decision. Unfavorable wind/windshear and the tall tower were contributing factors.NTSB MKC89DPG04Accident · Serious injuriesFinal reportRockwell S-2R · Moscow, ARInadequate visual lookout by the pilot. The guy wire was a contributing factor.NTSB DEN89LA186Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lovell, WYImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to continue out of the canyon or turn around. The terrain and high density altitude were related factors.NTSB DEN89DTG01Accident · 1 fatalFinal reportCessna 188A · Valley City, NDInadequate visual lookout by the pilot. The power line was a related factor.NTSB ATL89LA192Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Dunn, NCThe pilot's failure to properly calculate the takeoff distance required for the conditions and the airplane collided with power lines during climbout.NTSB ATL89LA191Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Gaines, GAThe pilot failed to maintain directional control of the airplane during takeoff, which resulted in a collision with trees adjacent to the runway.NTSB NYC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barker, NYThe pilot's decision to abort the landing too FAR down the runway. A factor was: the small tree located off the end of the runway.NTSB LAX89DUJ08Accident · No injuriesFinal reportAero Commander S2R · Tolleson, AZThe pilots failure to see and avoid contact with some wires.NTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB ANC89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Tozitna River, AKImproper preflight planning/preparation by the pilot. High obstructions, unfavorable wind conditions, and trees were contributing factors.NTSB BFO89DIG02Accident · Minor injuriesFinal reportPiper PA-28 · Cumberland, MDThe pilot's improper decision to takeoff in deteriorating weather conditions. Related factors were: the pilot's failure to obtain a weather briefing prior to departure, and his lack of an instrument rating.NTSB MKC89DPG03Accident · 1 fatalFinal reportPZL-Mielec M-18 · Parkin, ARThe failure of the pilot to maintain a visual lookout adequate to have avoided the powerlines.NTSB ATL89LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmington, NCThe inadequate preflight preparation/planning by the pilot regarding the unique light features on runway 18 (lights mounted along the east side only). In addition the pilot failed to align the airplane with the runway and struck a vehicle that was parked…NTSB ATL89DKJ08Accident · Serious injuriesFinal reportCessna A188B · Atmore, ALPilot's failure to maintain visual lookout for obstacles. Contributing to the accident was the low (dawn) position of the sun which interfered with the pilot's vision.NTSB LAX89DVD04Accident · Minor injuriesFinal reportTravel Air 4000 · Lodi, CAThe failure of the pilot to see and avoid power lines, while distracted by a moving vehicle on the ground.NTSB NYC89LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Atlantic City, NJThe pilot's failure to maintain adequate flying speed, and his delay to jettison the banner. A factor related to the accident was: the location of the trees.NTSB ATL89LA183Accident · No injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe pilot's improper go-around procedure of fully retracting the flaps which resulted in the airplane mushing into trees. Contributing factor(s) was: a misjudgement of flare height above the runway and failure to remove the carburetor heat which may have…NTSB LAX89FA241Accident · 3 fatalField investigationFinal reportCessna 177 · Hesperia, CAAn inflight collision with a power line while maneuvering at low altitude shortly after departure on a dark night over an area with few ground reference lights. The reasons for the aircraft's flight path and altitude profile are undetermined. A factor in the…NTSB MIA89LA202Accident · No injuriesLimited investigationFinal reportBell TH-13T · Jay, FLInadequate planning/decision by the pilot and his failure to maintain clearance from the power line. Contributing factors were: light conditions at dusk, transmission (power) lines, and the pilot's lack of visual cues (visual perception) at dusk.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…NTSB DEN89LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Haswell, COInadequate visual lookout by the pilot (failed to see & avoid) which resulted in his failure to maintain clearance from the obstruction. Contributing factors were: the unmarked guy wire & the pilot's lack of visual cues (visual perception).NTSB CHI89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Chippewa Falls, WIThe pilot's failure to maintain directional control while attempting to land in crosswind conditions. During the ensuing aborted landing, the pilot failed to ensure adequate obstacle clearance and the aircraft's left wing struck the wind sock pole.NTSB FTW89FA137Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Celina, TXImproper planning/decision by the pilot. Related factors were: failure of the pilot to use all of the available runway area, the runway/terrain conditions, and obstructions/power lines beyond the departure end of the runway.NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.NTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.NTSB SEA89LA132Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Middleton, IDThe pilot did not maintain an adequate visual lookout. A factor was the guy wires at the edge of the field.