NTSB investigations: NONE

141 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with object”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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.

NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.Oct 18, 1997 · N7583 · Substantial damageNTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.Oct 6, 1997 · N63459 · Substantial damageNTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.Aug 3, 1997 · N20146 · Substantial damageNTSB CHI97LA207Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Columbia, MOthe pilot's failure to properly judge the landing approach. The proximity of transmission wires was a related factor.Jul 5, 1997 · N1527B · Substantial damageNTSB LAX97LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Llano, CAthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper altitude and clearance from the boundry fence, during an approach to land on the runway. Factors relating to the accident were: the crosswind, and…Apr 12, 1997 · N2037T · Substantial damageNTSB MIA97LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Benton, TNThe failure of the pilot to maintain altitude and clearance from the trees on a ridge line.Mar 20, 1997 · N33WP · Substantial damageNTSB MIA97LA046Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mulberry, FLThe pilot's failure to check that the spoiler handle was locked in the retracted position prior to takeoff.Dec 22, 1996 · N48052 · Substantial damageNTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.Oct 30, 1996 · N15CB · Substantial damageNTSB CHI96LA349Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Stilwell, KSthe pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).Sep 22, 1996 · N2006W · No damageNTSB LAX96LA330Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Warner Springs, CAimproper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…Sep 9, 1996 · N3950B · Substantial damageNTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.Aug 24, 1996 · N7414U · Substantial damageNTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.Aug 4, 1996 · N11EK · Substantial damageNTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.Jun 19, 1996 · N65809 · Substantial damageNTSB FTW96LA242Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · San Angelo, TXfailure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.Jun 9, 1996 · N63286 · Minor damageNTSB NYC95LA156Accident · No injuriesLimited investigationFinal reportSchweizer S-2-33A · Elmira, NYThe pilot's delayed decision to return to the departure airport, which resulted in insufficient gliding altitude, and the subsequent off airport landing in the trees.Jul 9, 1995 · N3622X · Substantial damageNTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.Nov 19, 1994 · N33938 · Substantial damageNTSB CHI94LA280Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIno thermal lift available, and the lack of suitable terrain for landing. A factor related to the accident was the high wind condition.Aug 14, 1994 · N6514M · Substantial damageNTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.Apr 26, 1994 · N898ET · Substantial damageNTSB CHI94LA042Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Pratt, KSThe pilot-in-command's failure to maintain clearance from obstacles. Factors contributing to the accident are the pilot's misjudged fuel consumption calculations and the weather (high winds).Dec 5, 1993 · N9079M · Substantial damageNTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.Oct 28, 1993 · N7779S · Substantial damageNTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.Sep 6, 1993 · N34367 · Substantial damageNTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.Sep 5, 1993 · N2021A · Substantial damageNTSB NYC93LA173Accident · Serious injuriesLimited investigationFinal reportCameron Bieu/V-65 · Lewiston, NYThe pilot's failure to maintain adequate clearance, which resulted in an inflight collision with a light pole.Aug 26, 1993 · N75192 · Substantial damageNTSB LAX93LA250Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Salida, CAthe pilot's failure to attain the proper touchdown point during the attempted landing. A factor in the accident was the unfavorable wind conditions for the balloon landing.Jun 12, 1993 · N71145 · Minor damageNTSB LAX93LA283Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Phoenix, AZThe pilot's inadequate planned approach to the landing area.Apr 11, 1993 · N16131 · Substantial damageNTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.Aug 22, 1992 · N28267 · Substantial damageNTSB CHI92LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Manchester, MIThe pilot's improper inflight planning/decisions, failure to make a precautionary landing when he realized he was too low to reach the airport, and attempting to stretch his glidepath to reach the runway.Jul 5, 1992 · N2524H · Substantial damageNTSB MIA92LA028Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Groveland, FLPoor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.Nov 14, 1991 · N2890H · Substantial damageNTSB LAX92LA021Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Fremont, CAThe pilot's inadequate altitude on final approach.Oct 20, 1991 · N17886 · DestroyedNTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.Aug 4, 1991 · N3621X · Substantial damageNTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.Jul 28, 1991 · N2801F · Minor damageNTSB CHI91LA219Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Plainfield, ILPilot's failure to attain proper alignment with the runway. A factor related to the accident was the high vegetation/crop in which the landing was made.Jul 16, 1991 · N2477W · Substantial damageNTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.May 25, 1991 · N3609K · DestroyedNTSB LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.Aug 19, 1990 · N6774Q · DestroyedNTSB LAX90DXQ02Accident · Minor injuriesFinal reportLeffler/Mcfarlane LM-1 · Sierraville, CAPilot's failure to see and avoid a tree during his landing approach.Jul 30, 1990 · N9646Z · DestroyedNTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.Jul 21, 1990 · N2724H · Substantial damageNTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.Jul 8, 1990 · N65879 · Substantial damageNTSB 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.Jun 4, 1990 · N2423W · Substantial damageNTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.May 27, 1990 · N9811N · Substantial damageNTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.Mar 31, 1990 · N3837J · Substantial damageNTSB CHI90LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe dual student did not maintain proper glidepath and his misjudgment for compensation for wind conditions resulted in a collision with utility wires. The cfi's inadequate supervision during the duel flight operation contributed to the accident.Dec 3, 1989 · N2610H · Substantial damageNTSB LAX90LA041Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Sun City, AZInadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.Nov 25, 1989 · N4058F · Substantial damageNTSB BFO90LA021Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Paint Bank, VAThe pilot's improper inflight planning which led to an off-airport landing after encountering deteriorating lift conditions. Contributing factors were the mountainous terrain and lack of a suitable landing area.Nov 12, 1989 · N2880H · Substantial damageNTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.Nov 5, 1989 · N1998Y · Substantial damageNTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.Oct 8, 1989 · N3581D · Substantial damageNTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.Oct 8, 1989 · N1059S · Substantial damageNTSB 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.Aug 19, 1989 · N414LF · Substantial damageNTSB 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.Jul 16, 1989 · N85DP · DestroyedNTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.Jul 8, 1989 · N4069H · Substantial damageNTSB ATL89FA158Accident · 3 fatalField investigationFinal reportBalloon Works Firefly 8B · Garner, NCImproper planning/decision by the pilot, and his delay in initiating a climb as the Balloon converged on the tv tower.Jun 11, 1989 · N37141 · Substantial damage