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 FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.NTSB LAX90LA236Accident · No injuriesLimited investigationFinal reportCessna 172RG · Concord, CAThe student pilot's initiating an excessive descent and the cfi's inadequate remedial action.NTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.NTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.NTSB MKC90LA143Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Marshalltown, IAInadequate visual lookout and clearance not obtained.NTSB CHI90LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Millington, MIInadequate planning-decision, failure to obtain lift-off airspeed, and failure to perform an aborted takeoff. Factors related to the accident are the uphill sloping runway, soft turf, high grass, and complacency.NTSB DEN90LA145Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Monte Vista, COThe pilot's premature rotation and liftoff.NTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.NTSB NYC90DGM02Accident · 1 fatalFinal reportBell 47D1 · Meadville, PAThe pilot's failure to see and avoid the power lines.NTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.NTSB DEN90LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Hazelton, NDThe failure of the pilot in command to maintain adequate visual lookout during aerial application maneuvering.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB CHI90LA160Accident · No injuriesLimited investigationFinal reportMooney M20J/201 · Kelleys Island, OHThe pilot's failure to maintain clearance from objects during a go-around. Factor was unfavorable wind conditions.NTSB ANC90LA094Accident · No injuriesLimited investigationFinal reportCessna 170B · Port Chalmers, AKPilot-in-command's failure to properly calculate the airplane's takeoff performance and the effect of the crosswind.NTSB ATL90FA132Accident · 1 fatalField investigationFinal reportCessna 182E · Newland, NCAttempted VFR flight into instrument meteorological conditions.NTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.NTSB BFO90FA057Accident · 2 fatalField investigationFinal reportMooney M20E · Charleston, WVThe pilot's improper IFR procedures, his failure to maintain a proper glide path on the ILS approach, and his failure to initiate a missed approach at the decision height. The adverse weather was a related factor.NTSB MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.NTSB ATL90FA128Accident · 2 fatalField investigationFinal reportMooney M20J · Andrews, NCFailure of the pilot to maintain proper altitude/clearance over high terrain. Darkness and high terrain were related factors.NTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.NTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.NTSB CHI90LA154Accident · No injuriesLimited investigationFinal reportCessna 207 · Toledo, OHThe pilot-in-command's poor preflight planning and his failure to attain proper climb rate during initial climb after takeoff.NTSB ATL90LA131Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7CCM · Albany, GAFailure of the pilot in command to directional control on takeoff initial climb, and failure to maintain a visual lookout for obstacles.NTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.NTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB CHI90FA145Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Wadsworth, OHThe failure of the certified flight instructor and the dual student to maintain a visual lookout during the final approach to the airport.NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.NTSB BFO90LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-126E · Warrenton, VAThe pilot misjudged his landing approach.NTSB FTW90FA111Accident · No injuriesField investigationFinal reportSchweizer 269C · Tallulah, LALoss of control due to a multiple bird strike and incorrect control inputs by the pilot in the flare. Contributing factors were the bird strike induced vibrations and the main rotor blade contact with the tail rotor drive shaft.NTSB SEA90FA086Accident · 3 fatalField investigationFinal reportRockwell Commander 114 · Atlanta, IDPoor preflight planning premature lift-off on takeoff by the pilot in command.NTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.NTSB NYC90FA110Accident · No injuriesField investigationFinal reportBritten-Norman BN2A-2F · Blue Bell, PAThe close proximity of the road to the threshold of the runway. Factors contributing to the accident were the obstruction to the driver's vision caused by trees and buildings.NTSB NYC90DHA01Accident · 1 fatalFinal reportGrumman G-164A · Hunlock Creek, PAThe pilot's failure to maintain adequate clearance from obtacles, and his failure to see and avoid the electrical transmission line.NTSB NYC90DFG03Accident · No injuriesFinal reportContinental Copters MK15A · King Ferry, NYThe pilot's failure to maintain adequate clearance from power lines during this approach to landing.NTSB MIA90LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Leland, MSFailure of the pilot to see-and-avoid the power lines.NTSB SEA90LA081Accident · 1 fatalLimited investigationFinal reportHughes 369D · Kelso, WAFailure of the pilot to keep the external load clear of obstacles (trees). Factors related to the accident were: failure of the pilot and ground crewman to follow safety procedures, and the proximity of the trees.NTSB MIA90LA125Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Lake Wales, FLThe pilot's failure to maintain adequate clearance between the main rotor blades and a power line pole while maneuvering during an aerial application flight.NTSB CHI90FA131Accident · 1 fatalField investigationFinal reportRockwell 114 · Willoughby Hill, OHFailure of the pilot to follow the IFR procedure and to identify the decision height (and/or make a timely missed approach). The adverse weather was a related factor.NTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.NTSB LAX90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Terra Bella, CAThe pilot's preflight planning and preparation was poor. Contributing to this accident was the high vegetation field.NTSB DEN90LA111Accident · Minor injuriesLimited investigationFinal reportErco 415G · Peyton, COPilot's failure to maintain obstacle clearance during a landing.NTSB ATL90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jacksonville, NCThe pilot's decision to land downwind and his delay in executing a go-around.NTSB BFO90FA046Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Capon Bridge, WVInadequate visual lookout by the pilots of the DC-3, which resulted in their failure to see-and-avoid the powerlines. Factors related to the accident were: the obstruction (transmission wires), and the lack of visual cues for the pilots.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB LAX90FA170Accident · 1 fatalField investigationFinal reportBell 206B · Carmel Valley, CAThe pilot's inadequate visual lookout and improper climb.NTSB FTW90DRD08Accident · No injuriesFinal reportSchweizer G-164B · Basile, LAThe pilot's inadequate evaluation of the weather information. A related factor to the accident was the tailwind.NTSB MIA90FA118Accident · 2 fatalField investigationFinal reportCessna 172K · Mayaguez, PRThe pilot's failue to conduct proper preflight preparations, resulting in a takeoff at 175 pounds over maximum allowable gross weight, with full flaps extended, and on the improper runway for wind conditions which resulted in the airplane being unable to…