NTSB investigations
1,695 cases where the first occurrence was “On ground/water 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\" = 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."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 LAX90LA255Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · S. Lake Tahoe, CAThe pilot's failure to maintain clearance between the aircraft and an obstruction along his ground taxi route. Obstructions along the route and a fence constructed near the ramp are factors in the accident.NTSB ANC90LA107Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Eielson Afb, AKThe cfi's failure to take timely action when the dual student did not attain a proper touch down point.NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…NTSB LAX90LA254Accident · No injuriesLimited investigationFinal reportCessna T207A · Grand Canyon, AZThe pilot's misjudgement of clearance from a parked aircraft while taxiing.NTSB NYC90LA132Accident · No injuriesLimited investigationFinal reportBoeing 747-230 · Jamaica, NYThe Boeing 747 captain misjudged clearance between his aircraft and the fokker f.28. A factor related to the accident was: self-induced pressure of the Boeing 747 captain.NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB SEA90LA119Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hawthorne, NVThe pilot's selection of unsuitable terrain for landing.NTSB DEN90LA134Accident · No injuriesLimited investigationFinal reportCessna A185F · Erie, COFailure of the pilot receiving instruction to choose suitable terrain for the landing. Contributing to the accident was the cfi's inadequate supervision.NTSB SEA90LA089Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot did not adequately compensate for the cross wind conditions while taxiing and failed to maintain clearance between the airplane and a tree on the shoreline. The crosswind was a factor related to the accident.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.NTSB ANC90LA089Accident · No injuriesLimited investigationFinal reportCessna C-150M · Chakachamna, AKPilot-in-command's failure to properly survey the landing area and ensure the appropriate width for his airplane.NTSB MIA90LA122Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Daytona Beach, FLThe failure of the pilot of the tailwheel equipped airplane to maintain a visual lookout while taxiing.NTSB LAX90LA167Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF 260 · Chandler, AZThe second pilot's over rotation and the failure of the pilot in command to adequately supervise the conduct of the flight and to make a timely corrective action.NTSB LAX90LA147Accident · No injuriesLimited investigationFinal reportBeech F-33A · Goodyear, AZThe pilot's failure to follow directives and his misjudgement of distance. Contributing to the accident was the airport management's failure to ensure that the building did not pose a hazard.NTSB MIA90FA105Accident · No injuriesField investigationFinal reportEmbraer EMB-110 · Fort Lauderdale, FLThe pilot in command's failure to maintain an adequate visual look-out due to his self imposed pressure of taxiing, completing cockpit checklists and obtaining a clearance at the same time.NTSB LAX90LA146Accident · No injuriesLimited investigationFinal reportBeech F33A · Yuba City, CAA dog suddenly running onto the active runway in front of the aircraft resulted in a collision and substantial airframe damage.NTSB ANC90LA049Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kayak Island, AKThe pilot's failure to use a suitable area to taxi for takeoff. The hidden obstruction (log) was a related factor.NTSB LAX90LA116Accident · 1 fatalLimited investigationFinal reportBoeing 727-227 · Phoenix, AZThe unauthorized intrusion onto the runway environment by a pedestrian.NTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.NTSB NYC90LA066Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe pilot of N349MA failed to see and avoid another airplane taxiing in the same direction.NTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.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 DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB MKC90LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNInadequate visual outlook by the pilot and his failure to maintain clearance from the light pole. The location of the pole was considered to be a related factor.NTSB LAX90LA063Accident · No injuriesLimited investigationFinal reportMooney Mark 22 · Apple Valley, CAThe failure of the pilot of the Mooney to stop his aircraft in a timely manner to avoid a collision.NTSB SEA90LA031Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe pilots inadequate visual lookout while taxiing. Factors related to the accident are: the pilot's diverted attention and the pole.NTSB ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.NTSB LAX90LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Monterey, CAPilot misjudged clearance between the aircraft's wing tip & the fuel truck. A factor related to the accident was: the proximity of the vehicle (fuel truck).NTSB LAX90LA081Accident · No injuriesLimited investigationFinal reportCessna 414 · Bullhead City, AZThe pilot's failure to maintain sufficient clearance between his aircraft and ground objects during a taxi to the ramp area.NTSB ANC90LA018Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Kotzebue, AKPhysical impairment of the vehicle driver, from consumption of alcohol, which resulted in a collision with the airplane. The vehicle and dark night were considered to be related factors.NTSB LAX90LA045Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Van Nuys, CAThe P-51 pilot's failure to see and avoid the standing C-172.NTSB MIA90IA036Incident · No injuriesIncident investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to adequately watch for parked aircraft after becoming distracted.NTSB CHI90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeport, ILThe pilot-in-command's failure to properly judge the clearance between his airplane and a parked vehicle.NTSB ANC90LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadequate preflight preparation and failure to identify suitable terrain for takeoff.NTSB ATL90LA026Accident · No injuriesLimited investigationFinal reportLearjet 24 · Atlanta, GAThe pilot in command's failure to insure his airplane was clear of a parked aircraft while maneuvering to park.NTSB SEA90LA014Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot failed to adequately compensate for tailwind conditions when landing on a short wet runway.NTSB SEA90LA026Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Newberg, ORFailure of the pilot to maintain runway alignment. The birds & debris (hidding obstructions) were related factors.NTSB LAX90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ontario, CAImproper use of the brakes by the pilot of the Piper PA-31.NTSB CHI90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed. Factors related to the accident were: the runway condition & obstructions.NTSB MKC90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Brooten, MNThe pilot's failure to use proper starting procedures and the excessive throttle setting.NTSB NYC90LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Philadelphia, PAThe failure of the pilot of N333TQ to taxi at a speed that would allow him to stop under existing conditions of visibility and taxiway conditions.NTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.NTSB NYC90LA005Accident · No injuriesLimited investigationFinal reportCessna 170B · Burlington, CTThe aircraft colliding with a steel drum placed on the runway by unknown person(s) to mark a pothole area.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MKC89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · North Omaha, NEThe pilot's selection of unsuitable terrain on which to make a simulated forced landing.NTSB LAX89DUM04Accident · No injuriesFinal reportBeech D175 · El Cajon, CAInadequate visual lookout by the pilot of the other aircraft (N9645H).NTSB MIA89LA256Accident · Serious injuriesLimited investigationFinal reportCooley LONG-EZ · Green Cove Spgs, FLImproper planning/decision by the pilot, which resulted in his failure (or inability) to align the acft with the runway during the landing. The low ceiling, tailwind, and ditch were related factors.NTSB LAX89LA325Accident · No injuriesLimited investigationFinal reportCessna 172 · Phoenix, AZThe pilot misjudged clearance between the wingtip and the blast deflector shield. The proximity of the shield was a related factor.NTSB LAX89LA317Accident · No injuriesLimited investigationFinal reportCessna 182 · Zenia, CAFailure of the pilot to realize that the flaps did not extend, which resulted in excessive airspeed. The seized flap actuator was a related factor.