Skip to content

NTSB investigations

1,695 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.Aug 29, 1992 · N8410R · Substantial damage NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…Aug 25, 1992 · N1109F · Substantial damage NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.Aug 21, 1992 · N2353L · Substantial damage NTSB ANC92LA149Accident · No injuriesLimited investigationFinal reportCessna 182P · Montague Island, AKThe pilot in command did not properly align the airplane with the airstrip landing zone. A factor which contributed to the accident were the trees.Aug 16, 1992 · N7388Q · Substantial damage NTSB NYC92LA157Accident · No injuriesLimited investigationFinal reportBoeing 747-238 · Newark, NJThe airport authority's failure to assure adequate obstacle clearance for aircraft manuevering around the ramp area.Aug 11, 1992 · GVOIG · Substantial damage NTSB FTW92DPG11Accident · No injuriesFinal reportGrumman G-164B · Fouke, ARThe pilot's selection of unsuitable terrain for takeoff. Factors were the trees and the soft field.Aug 4, 1992 · N3630U · Substantial damage NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.Jul 27, 1992 · N731MR · Substantial damage NTSB MIA92LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCFailure of the pilot-in-command to maintain adequate wingtip clearance with bushes off the side of the taxiway while taxiing to takeoff.Jul 26, 1992 · N25502 · Substantial damage NTSB LAX92IA307Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAA failure of ground personnel to ensure proper clearance between a taxiing airplane and an adjacent parked airplane. Contributing to the accident was a failure of ground personnel to properly position a parked airplane to ensure that it did not encroach into…Jul 18, 1992 · N719DA · 2 aircraft · No damage NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.Jul 18, 1992 · N1342 · Substantial damage NTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.Jul 4, 1992 · N4037Q · Minor damage NTSB LAX92LA286Accident · No injuriesLimited investigationFinal reportCessna 172G · Tonopah, NVThe failure of the pilot to adequately identify and compensate for the existing tailwind conditions, and, his failure to initiate a go around when he became aware of being high with a fast ground speed.Jul 3, 1992 · N4417L · Substantial damage NTSB ANC92IA097Incident · No injuriesIncident investigationFinal reportCessna 150 · Anchorage, AKThe driver of the other vehicle not following procedures and directives and colliding with the airplane.Jun 26, 1992 · N66281 · Minor damage NTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.Jun 25, 1992 · N88522 · Substantial damage NTSB LAX92LA261Accident · No injuriesLimited investigationFinal reportCessna 140 · Newhall, CAThe pilot's poor judgment and his overconfidence in his ability to fly his airplane.Jun 24, 1992 · N76962 · Substantial damage NTSB ANC92LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kantishna, AKThe pilot in command's excessive taxi speed. Factors relating to the accident were the crosswind and dusk light conditions.Jun 21, 1992 · N7850H · Substantial damage NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.Jun 20, 1992 · N81229 · 2 aircraft · Substantial damage NTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.Jun 17, 1992 · N4567S · Destroyed NTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.Jun 15, 1992 · N8285K · Destroyed NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.Jun 13, 1992 · N3117 · Substantial damage NTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.Jun 13, 1992 · N8303Q · Substantial damage NTSB ANC92LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKInadequate visual look out by the pilot of both aircraft. Contributing to the accident were the pilot's diverted attention, the other moving aircraft/object (c 172), and the excessive taxi speed of the c 172.Jun 10, 1992 · N61670 · 2 aircraft · Minor damage NTSB FTW92LA153Accident · No injuriesLimited investigationFinal reportPokorney Smith Mini DSA-1 · Groom, TXThe pilot's selection of the unsuitable landing area. Factors were the weather condition and the road sign.Jun 7, 1992 · N2MP · Substantial damage NTSB CHI92LA164Accident · Serious injuriesLimited investigationFinal reportGrumman AA5B · Charlotte, MIThe pedestrian's failure to maintain visual outlook and separation from the taxiing aircraft.Jun 7, 1992 · N45199 · No damage NTSB ATL92LA117Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Williamson, GAThe failure of the pilot of N46RB (the sonerai) to maintain proper runway alignment during the takeoff roll, and his inadequate visual lookout. A factor was the lack of runway edge markings at this airport.Jun 6, 1992 · N6810K · 2 aircraft · Substantial damage NTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.Jun 5, 1992 · N8732H · Destroyed NTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.Jun 5, 1992 · N83453 · Substantial damage NTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.Jun 3, 1992 · N2724H · Substantial damage NTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.May 31, 1992 · N4163L · Substantial damage NTSB CHI92LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Climax Springs, MODelay in aborting the landing by the pilot in command.May 19, 1992 · N80255 · Substantial damage NTSB BFO92LA067Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Vine Grove, KYThe pilot's failure to maintain directional control. Contributing factors were wind gusts and the pilot's inadequate compensation for wind.May 17, 1992 · N93426 · Substantial damage NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.May 13, 1992 · N1518V · 2 aircraft · Substantial damage NTSB ANC92LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Tolovana, AKThe pilot's failure to use all of the available runway (landing area on the road) for the precautionary landing. Contributing to the accident were the precautionary landing, the pilot's inadequate pre flight and in flight planning/preparation, and the road…Apr 19, 1992 · N3405R · Substantial damage NTSB NYC92LA083Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Lexington, KYAttempted suicide by the vehicle driver.Apr 18, 1992 · N27465 · Substantial damage NTSB FTW92IA104Incident · No injuriesIncident investigationFinal reportBeech 1900C · Lamar, COFailure of the pilot to maintain clearance. A factor was the bright sun.Apr 4, 1992 · N137YV · Minor damage NTSB FTW92LA100Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Hayden, COFailure of the ground personnel to follow published procedures/directives. A factor was the inadequate equipment.Mar 27, 1992 · N615AM · No damage NTSB BFO92IA046Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Louisville, KYInadequate obstacle clearance, which resulted in on ground collision with a blast fence. Contributing was inadequate instruction from ground personnel.Mar 19, 1992 · N681UP · Minor damage NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.Mar 4, 1992 · N4495C · Substantial damage NTSB ANC92LA041Accident · Minor injuriesLimited investigationFinal reportDe Havilland DH6 · Anchorage, AKInadequate visual look out by both pilots in the airplane, and the driver of the ground vehicle. Contributing factors to the accident were the absence of side conspicuity lighting on the ground vehicle, and the night lighting conditions.Feb 24, 1992 · N723CA · Substantial damage NTSB NYC92LA069Accident · No injuriesLimited investigationFinal reportCessna 150 · Sanford, METhe failure of the pilot of N64147 to maintain adequate spacing and visual lookout from N6544G while taxiing, resulting in a ground collision.Feb 15, 1992 · N6544G · 2 aircraft · Substantial damage NTSB MIA92IA077Incident · No injuriesIncident investigationFinal reportBoeing 767-323ER · Miami, FLThe failure of the FAA local controller to asure adequate clearance was established.Feb 9, 1992 · N354AA · 2 aircraft · Minor damage NTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.Feb 8, 1992 · N46021 · Substantial damage NTSB CHI92LA089Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Wheeling, ILImproper starting procedure attempted by the pilot. A factor related to the accident was: magneto switch left in the 'on' position.Feb 6, 1992 · N9029V · Substantial damage NTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.Jan 11, 1992 · N7000L · 2 aircraft · Substantial damage NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.Jan 2, 1992 · N40799 · Substantial damage NTSB DEN92LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder, COFailure of the pilot to maintain clearance from the sign.Nov 20, 1991 · N80893 · Substantial damage NTSB BFO92LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Portsmouth, VACollisiion with the deer on the runway. A factor was the dark night.Nov 15, 1991 · N19595 · Substantial damage NTSB ANC92LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Ekuk, AKThe pilot's improper in flight planning and decision in that he attempted to touchdown too close to the log.Oct 31, 1991 · N46279 · Substantial damage NTSB MIA92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Daytona Beach, FLThe failure of the pilot in command of N136AT to maintain clearance from N3110R while diverting her attention to close her door during taxi to takeoff.Oct 24, 1991 · N136AT · 2 aircraft · Substantial damage NTSB NYC92FA009Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Newark, NJFailure of the crew of the B-737, N7385F, to maintain adequate visual lookout while taxiing, and failure by air traffic controllers to provide traffic information and/or issue warnings to either flightcrew. A factor was the after-landing task saturation of…Oct 17, 1991 · N498AA · 2 aircraft · Substantial damage