Final NTSB investigations, NJ

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
  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 DCA12FA046Accident · Serious injuriesField investigationFinal reportAirbus A321 · Millville, NJan encounter with convective turbulence that resulted in injury to a passenger who was not seated when the seatbelt sign was illuminated.Feb 24, 2012 · N162UW · No damageNTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.Feb 18, 2012 · N506SP · Substantial damageNTSB ERA12FA115Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Morristown, NJThe airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…Dec 20, 2011 · N731CA · DestroyedNTSB ERA12CA083Accident · Minor injuriesData collectionFinal reportCessna 162 · Lincoln Park, NJThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control, a runway excursion, and collision with trees.Nov 25, 2011 · N5216J · Substantial damageNTSB ERA12CA004Accident · No injuriesData collectionFinal reportCessna 182P · Lincoln Park, NJThe pilot's improper landing flare.Oct 2, 2011 · N1835M · Substantial damageNTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.Aug 20, 2011 · N71DM · 2 aircraft · Substantial damageNTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.Aug 2, 2011 · N87020 · Substantial damageNTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.Jul 23, 2011 · N869BC · Substantial damageNTSB ERA11LA409Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Dayton, NJThe pilot's inadequate compensation for wind during an out-of-ground-effect hover, which resulted in a loss of control due to settling with power and loss of tail rotor effectiveness.Jul 20, 2011 · N83509 · Substantial damageNTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…Jul 9, 2011 · N111XN · Substantial damageNTSB ERA11LA380Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Lakewood, NJThe pilot’s inadequate yaw control of the helicopter while hovering.Jul 4, 2011 · N64JM · Substantial damageNTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.Jun 20, 2011 · N87020 · Substantial damageNTSB ERA11CA356Accident · No injuriesData collectionFinal reportCessna A185F · Trinca, NJThe pilot's failure to maintain directional control, and the flight instructor's inadequate remedial action, which resulted in a ground-loop.Jun 18, 2011 · N714TX · Substantial damageNTSB ERA11CA277Accident · No injuriesData collectionFinal reportCessna A185F · Ocean City, NJThe pilot's failure to maintain directional control during the takeoff roll.May 3, 2011 · N6389E · Substantial damageNTSB ERA11CA275Accident · No injuriesData collectionFinal reportBeech A23 · Hammonton, NJThe pilot's failure to maintain directional control during the aborted takeoff.May 1, 2011 · N3594R · Substantial damageNTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.Apr 21, 2011 · N113CS · Substantial damageNTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.Apr 10, 2011 · N6338F · Substantial damageNTSB ERA11CA225Accident · Serious injuriesData collectionFinal reportPiper PA38 · Manville, NJThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel starvation.Apr 2, 2011 · N2491K · Substantial damageNTSB ERA11CA193Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Pittstown, NJThe student pilot's inadequate flare and the certified flight instructor's inadequate remedial action, which resulted in a hard landing.Mar 8, 2011 · N470Q · Substantial damageNTSB ERA11CA171Accident · No injuriesData collectionFinal reportAerostar PA-60-601P · Princeton, NJThe pilot’s failure to stop the airplane resulting in a runway overrun.Feb 25, 2011 · N444TT · Substantial damageNTSB ERA11LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe pilot’s inadequate preflight inspection (removal of water contamination from the fuel system), which resulted in a total loss of engine power.Feb 10, 2011 · N25HD · Substantial damageNTSB ERA11LA093Accident · Serious injuriesLimited investigationFinal reportCessna 182 · West Milford, NJThe pilot's delayed application of carburetor heat while taking off in weather conditions conducive to serious carburetor icing, which resulted in a partial loss of engine power.Dec 18, 2010 · N1462M · Substantial damageNTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.Nov 13, 2010 · N15499 · Substantial damageNTSB OPS11IA054Incident · No injuriesIncident investigationFinal reportDassault FALCON900EX · Teterboro, NJThe pilot of the F900 overshooting of the final approach course, which conflicted with traffic in the pattern. Contributing to the accident was the lack of appropriate coordination between the tower controller and the approach controller.Oct 20, 2010 · PHILC · 3 aircraft · No damageNTSB ERA11IA006Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe pilot-in-command's failure to attain the proper touchdown point while landing with a gusting crosswind and failure to initiate a go-around, which resulted in a landing more than halfway down the runway and a subsequent runway overrun. Contributing to the…Oct 1, 2010 · N923CL · Minor damageNTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.Sep 14, 2010 · N313MA · Substantial damageNTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.Aug 21, 2010 · N209RC · Substantial damageNTSB ERA10FA347Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Fairfield, NJThe pilot's failure to maintain aircraft control during the go-around following a hard landing. Contributing to the accident was the pilot's continuance of an unstabilized final approach and the improper use of flaps during the go-around.Jul 5, 2010 · N764CD · Substantial damageNTSB ERA10LA322Accident · Serious injuriesLimited investigationFinal reportCessna 172N · West Milford, NJThe student pilot’s control interference which resulted in a landing with a higher than normal airspeed, and the commercial pilot’s failure to initiate a go-around to avoid the runway overrun.Jun 20, 2010 · N738QZ · Substantial damageNTSB ERA10CA304Accident · No injuriesData collectionFinal reportCessna 305A · Toms River, NJThe pilot-in-command's loss of airplane control during landing, which resulted in a ground-loop.Jun 8, 2010 · N5075K · Substantial damageNTSB ENG10IA026Incident · No injuriesIncident investigationFinal reportAirbus A320 · Newark, NJThe separation of both halves of the left engine fan cowl assembly due to improper latching and locking of the all the fan cowl latches. The cause of the improper latching and locking of the fan cowls was due to the failure of the mechanic to unstow and…Apr 5, 2010 · N535JB · Minor damageNTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damageNTSB ERA10LA193Accident · No injuriesLimited investigationFinal reportBeech B95 · Lumberton, NJThe pilot's inadvertent retraction of the landing gear during the landing rollout.Mar 21, 2010 · N1572L · Substantial damageNTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…Feb 15, 2010 · N12NA · Substantial damageNTSB DCA10IA021Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Newark, NJA mechanical failure of internal components of the right main landing gear door actuator resulting in the flight crew being unable to fully extend the right main landing gear using the normal and alternate procedures. Contributing to this incident was a…Jan 10, 2010 · N816UA · Minor damageNTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.Nov 21, 2009 · N909CW · Substantial damageNTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…Nov 14, 2009 · N4499T · Substantial damageNTSB ENG09IA018Incident · No injuriesIncident investigationFinal reportBoeing 767 · Newark, NJFailure of Main Landing Gear (MLG) truck beam was due to contamination of the inner surface corrosion protective layers from hydraulic fluid and deice fluid that resulted in corrosion and intergranular stress corrosion cracking.Sep 18, 2009 · N66051 · Minor damageNTSB ERA09LA481Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rockaway, NJA total loss of engine power due to oil starvation for undetermined reasons.Aug 25, 2009 · N6117R · Substantial damageNTSB ERA09LA469Accident · 1 fatalLimited investigationFinal reportRaytheon 58 · Teterboro, NJThe complete loss of thrust due to the second-in-command’s (SIC) inadvertent feathering of both propellers during a high-speed, low-altitude approach. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the SIC’s performance.…Aug 21, 2009 · N167TB · Substantial damageNTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.Aug 18, 2009 · N7556H · Substantial damageNTSB ERA09LA459Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sussex, NJThe pilot’s improper pre-flight planning and take off over gross weight limits.Aug 12, 2009 · N6676S · Substantial damageNTSB ERA09MA447Accident · 9 fatalClass 1 · MajorFinal reportPiper PA-32R-300 · Hoboken, NJ(1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…Aug 8, 2009 · N71MC · 2 aircraft · Substantial damageNTSB ERA09CA437Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's improper flare, which resulted in a bounced landing, and the subsequent collapse of the landing gear.Aug 2, 2009 · N551N · Substantial damageNTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.Jul 27, 2009 · N1494X · Substantial damageNTSB ERA09LA409Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Mahwah, NJA loss of engine power due to the failure of the No. 1 cylinder thru bolt hold down nuts due to corrosion.Jul 19, 2009 · N8339A · Substantial damageNTSB ERA09LA384Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Ocean City, NJAn in-flight collision with birds during landing. Contributing to the accident was the airport's lack of a wildlife mitigation program.Jul 4, 2009 · N6502A · Substantial damageNTSB ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.Jul 4, 2009 · N64178 · Substantial damageNTSB ERA09CA391Accident · No injuriesData collectionFinal reportCessna 172RG · Morristown, NJThe pilot's failure to maintain clearance from a parked aircraft during taxi operations.Jul 4, 2009 · N751DW · Substantial damageNTSB ERA09LA368Accident · Serious injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Woodbine, NJA loss of engine power due to fuel starvation as a result of the pilot's improper fuel transfer in flight.Jun 25, 2009 · N300FA · Substantial damage