NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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\" = 230) 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" = 230) 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 CHI88LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172 · North Liberty, INWhile departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…NTSB CHI88DET03Accident · No injuriesFinal reportDavis Heath Model V · Valparaiso, INThe plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed…NTSB ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…NTSB DEN88FA107Accident · 2 fatalField investigationFinal reportStinson 108-2 · Mosca, COAfter purchasing acft, plt and plt-rated friend (both airline plts) were joined by plt's wife and departed falcon field, mesa, AZ, en route to MN. The trio stopped in alamosa, CO, for night. They departed alamosa (elevation 7608 ft MSL) the next morning and…NTSB CHI88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Nauvoo, ILThe pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…NTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.NTSB ANC88LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kodiak, AKThe pilot stated that during the takeoff run he lost control of the aircraft causing the aircraft to nose over on its back at the departure end of the lake. The plt had been issued a special VFR clearance by Kodiak tower due to existing wx conditions. The plt…NTSB LAX88FA176Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Guatay, CAFailure of the pilot to maintian VFR while flying in mountainous terrain.NTSB ANC88LA053Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kotzebue, AKThe aircraft crashed five miles south of the city along the beach line. FAA inspectors, the Alaska state troopers accident report and several witnesses revealed that the pilot stated prior to the flight that he intended to commit suicide. The plt had a fight…NTSB ANC88FA051Accident · 2 fatalField investigationFinal reportBeech C55 · Tyonek, AKThe two pilots were operating the aircraft under the authority of a ferry permit which allowed flt only during day VFR conditions and with a single pilot. They requested and received just the weather at the destination airport, which was VMC. En route the flt…NTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…NTSB LAX88FA162Accident · 2 fatalField investigationFinal reportCessna 210L · Maricopa, CAAircraft inadvertent flight into instrument meteorological conditions.NTSB MKC88LA076Accident · No injuriesLimited investigationFinal reportCessna 182E · Clarksville, ARWhile attempting to land at night on a radio activated runway lighted airport, PIC was unable to activate the system. After several attempts to activate the runway lights, he elected to land on the unlighted runway. He aligned about 20 yards right of…NTSB LAX88LA160Accident · No injuriesLimited investigationFinal reportBell 47D1 · Taft, CANTSB SEA88LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Mead, NVThe pilot was flying very close to the water for the purpose of dropping beer to friends. The pilot allowed the aircraft to inadvertently descend and strike the water.NTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…NTSB ATL88FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bowling Green, KYPilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…NTSB ANC88DAG03Accident · No injuriesFinal reportPiper PA-14 · Glennallen, AKThe pilot stated that he was flying up a fairly wide valley containing a ridge that he had to fly over. The ground was completely white with snow. The pilot noticed a hill directly in front of the aircraft; he started a turn and the aircraft struck the snow…NTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…NTSB ATL88LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Guntersville, ALThe seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with…NTSB SEA88LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gold Bar, WAThe instructor pilot and his dual student flew into a canyon area. The aircraft was allowed to fly too close to rising terrain which the aircraft was unable to outclimb. During a turn to reverse direction the aircraft collided with terrain. The CFI stated…NTSB ATL88LA111Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Maiden, NCThe aircraft had been flying a series of low level maneuvers over the city. The pilot was attempting to recover from an intentional spin close to the ground when the aircraft struck utility lines and impacted the ground.NTSB ANC88LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mekoryuk, AKThe pilot stated that during the touchdown the aircraft struck a snowbank on the approach end of the runway. The aircraft exited the right side of the runway approximately 500 feet from the approach end.NTSB LAX88FA113Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Rosamond, CADecision of the pilot to attempt multiple low level passes over a residence in an area of rising terrain. Contributing to the accident was the significant levels of methamphetamine and amphetamine found in both the pilot's blood and urine specimens. A factor…NTSB ATL88IA096Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Elyria, OHNTSB NYC88LA088Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Morristown, NJThe Mooney crashed while on a ILS approach at night. The plt had been unable to get into two other airports due to weather and air traffic. The aircraft impacted in swampy area. The pilot had told ATC that he felt uneasy about his engine; however, he did not…NTSB NYC88FA093Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Stratford, CTThe pilot and pilot-rated pax received vectors for multiple ILS approaches in deteriorating conditions. On the first attempt the aircraft passed over witnesses but was off course and not in a position to land. The second attempt was aborted before reaching…NTSB LAX88FA114Accident · 2 fatalField investigationFinal reportBeech A23 · Big Bear City, CAThe passenger told friends that the pilot was going to perform some aerobatic maneuvers near the lodge where they were staying. The other residents in the lodge reported that the airplane flew very low over the house and proceeded towards the east. After…NTSB CHI88DEE02Accident · 1 fatalFinal reportHill Bushby Mustang II · Yorkville, ILPerformance of aerobatic maneuvers with insufficient altitude for recovery.NTSB LAX88LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Seneca, AZNTSB MIA88FA105Accident · 1 fatalField investigationFinal reportCessna 425 · Sanford, FLThe flt was cleared for a night ILS apch & advised that twr at dest had closed. Twr had rptd at closing that fog was forming & the flt was advised of the fog. The acft was located on a remote part of the arpt the next morning. The ELT had activated but the…NTSB LAX88DVD02Accident · No injuriesFinal reportCessna A188B · Lodi, CANTSB DEN88FA063Accident · 3 fatalField investigationFinal reportCessna 421A · Helena, MTThis accident occurred during a night, ILS app to rwy 27 in IMC. The acft collided with a mountain 12 NM ese of the arpt while turning inbound to intercept the LOC course. Investigation revealed that one VOR receiver was set on the destinaton ILS freq, the…NTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…NTSB ANC88LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Cold Bay, AKThe ATP certificated pilot in command departed on a solo, cargo-only air-taxi flight at 1104 a.k.s.t. for a destination 83SM to the n.e. the pilot was normally assigned to copilot duties on a multi-engined airplane, and was not familiar with the terrain he…NTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…NTSB DCA88MA017Accident · 9 fatalMajor investigationFinal reportFairchild SA-227AC · Bayfield, COThe aircraft was operating as Continental express flight 2286. During the approach in IFR conditions, the aircraft went below the minimum descent altitude then struck the terrain at 7180 feet MSL. Exam of the aircraft did not disclose any pre-impact failures…NTSB FTW88LA053Accident · No injuriesLimited investigationFinal reportBeech V35B · Temple, TXThe pilot failed to execute a missed approach when he descended through decision height.NTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…NTSB CHI88LA050Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Red Lake Falls, MNNTSB SEA88LA080Accident · 2 fatalLimited investigationFinal reportCessna 180 · Hailey, IDThis Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…NTSB MKC88FA037Accident · No injuriesField investigationFinal reportBeech 58 · Dewitt, ARThe pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,…NTSB FTW88MA047Accident · 2 fatalMajor investigationFinal reportGates Learjet 36A · Monroe, LAThe crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…NTSB MIA88FA081Accident · 1 fatalField investigationFinal reportCessna 152 · Parkland, FLAcft was seen descending in a near vertical dive at a high rate of speed with no rotation along the roll axis. The acft crashed nose first into a newly planted corn field. Post crash examination of the acft structure, flight controls, and engine revealed no…NTSB ATL88FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Anniston, ALThe VFR pilot continued the flight into deteriorating weather conditions and attempted to descend below the lowering clouds until the aircraft was too low to turn around safely and return to VFR flight conditions. The aircraft collided with trees and struck…NTSB DEN88FA036Accident · 1 fatalField investigationFinal reportCessna A152 · Benson, AZAbt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the…NTSB DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…NTSB LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…NTSB SEA88LA022Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Las Vegas, NVDuring practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present.NTSB SEA88LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sequim, WADuring dark night visual meteorological conditions, the aircraft struck trees while in cruise flt at about 2,000 feet MSL. Although the pilot had requested VFR traffic advisories, he did not solicit the use of the low altitude alert system. This system was…