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 ERA15IA206Incident · No injuriesIncident investigationFinal reportCessna 525B · Teterboro, NJThe overstress fracture of the nose landing gear actuator (NLG) attachment lug during tow operations, which resulted in the collapse of the NLG.May 3, 2015 · N784JS · Minor damageNTSB GAA15CA035Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot's improper flare which resulted in a loss of control and subsequent hard landing.Apr 6, 2015 · N179BA · Substantial damageNTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.Dec 4, 2014 · N8296Z · Substantial damageNTSB ERA15CA043Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Old Bridge, NJThe pilot's loss of control while landing the tailwheel-equipped airplane in gusting wind conditions, which resulted in a ground loop.Nov 3, 2014 · N7102D · Substantial damageNTSB ERA14LA405Accident · Minor injuriesLimited investigationFinal reportHiller UH 12E · Cape May Court House, NJThe mechanic’s failure to detect excessive wear on the engine’s lateral snubber vibration mount during the latest annual inspection, which resulted in an in-flight engine failure and a subsequent forced landing.Aug 25, 2014 · N4035A · Substantial damageNTSB ERA14LA401Accident · No injuriesLimited investigationFinal reportCessna 150G · Pittstown, NJA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Aug 21, 2014 · N2466J · Substantial damageNTSB ERA14CA394Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · Readington, NJThe pilot's failure to maintain aircraft control during landing which resulted in an aircraft nose-over.Aug 16, 2014 · N211A · Substantial damageNTSB ERA14LA342Accident · Serious injuriesLimited investigationFinal reportHolmlund Victor P Auriga · Manville, NJThe pilot’s improper preflight fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.Jul 16, 2014 · N234VV · Substantial damageNTSB DCA14CA124Accident · Serious injuriesData collectionFinal reportBoeing 767 424ER · Newark, NJA hot liquid splashed from a meal box onto the flight attendant's hand, resulting in a 2nd degree burn.Jun 17, 2014 · N77066 · No damageNTSB ERA14LA254Accident · Serious injuriesLimited investigationFinal reportJohn V Rawson JR Sprint II · Princeton, NJThe pilot’s failure to maintain airplane control during the approach to land. Contributing to the accident was the pilot’s unfamiliarity with and lack of training in the accident airplane make and model.May 21, 2014 · N505CR · Substantial damageNTSB ERA14CA250Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Sussex, NJThe pilot's failure to maintain proper airspeed while on approach, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.May 21, 2014 · N9592W · Substantial damageNTSB ERA14FA232Accident · 1 fatalField investigationFinal reportNavion G · Hamilton Township, NJThe pilot's mismanagement of the onboard fuel supply, which resulted in fuel starvation to the engine and a subsequent loss of engine power. Contributing to the death of the right front passenger was the inadequate occupant restraint.May 10, 2014 · N2473T · Substantial damageNTSB ERA14CA216Accident · No injuriesData collectionFinal reportAgusta Aerospace AW119 Mkii · Lumberton, NJThe flightcrew's improper recovery from a simulated engine failure after takeoff. Contributing to the accident was the flight instructor's failure to clarify who had control of the helicopter.May 1, 2014 · N119HF · Substantial damageNTSB ERA14CA211Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Woodbine, NJThe flight instructor's delayed reaction to the loss of directional control, which resulted in a ground loop.Apr 27, 2014 · N4615Y · Substantial damageNTSB OPS14IA005Incident · No injuriesIncident investigationFinal reportEmbraer EMB 145XR · Newark, NJThe local controller’s failure to comply with Federal Aviation Administration separation requirements for aircraft operating on intersecting runways.Apr 24, 2014 · N11176 · 2 aircraft · No damageNTSB ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.Apr 19, 2014 · N2219T · Substantial damageNTSB ERA14CA151Accident · No injuriesData collectionFinal reportCessna 172M · Pittstown, NJThe pilot's failure to maintain directional control while landing.Mar 7, 2014 · N1319U · Substantial damageNTSB ERA14LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJA partial loss of engine power at takeoff for reasons that could not be determined during a postaccident examination or engine test run.Mar 4, 2014 · N1449H · Substantial damageNTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.Feb 17, 2014 · N426SP · Substantial damageNTSB ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.Feb 11, 2014 · N381PT · Substantial damageNTSB ERA14CA118Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Sussex, NJThe pilot's improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Feb 9, 2014 · N103KW · Substantial damageNTSB ERA14FA093Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Holland, NJThe pilot's continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.Jan 15, 2014 · N469J · Substantial damageNTSB ERA14CA081Accident · No injuriesData collectionFinal reportCessna 172N · Farmingdale, NJThe student pilot's improper landing flare, which resulted in a hard landing.Dec 13, 2013 · N2854E · Substantial damageNTSB ERA14CA016Accident · No injuriesData collectionFinal reportDenisar Richard A Lancair 320 · Lumberton, NJA hard landing by the pilot, which resulted in overload failure of landing gear components and surrounding structure.Oct 22, 2013 · N825D · Substantial damageNTSB ERA14CA012Accident · No injuriesData collectionFinal reportClassic Waco YMF · Somerville, NJThe pilot's failure to maintain aircraft control while applying wheel brakes during landing roll resulting in the airplane nosing over.Oct 15, 2013 · N62XX · Substantial damageNTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.Sep 29, 2013 · N7626R · Substantial damageNTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.Sep 20, 2013 · N174BK · DestroyedNTSB ERA13CA420Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS 6 · Sussex, NJThe pilot's improper selection of an off-airport landing site, and his subsequent failure to maintain clearance from trees during a crosswind landing in gusty wind conditions.Sep 13, 2013 · N650DP · Substantial damageNTSB ERA13LA339Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Farmingdale, NJThe airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.Jul 26, 2013 · N61929 · Substantial damageNTSB ERA13CA316Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Blairstown, NJThe flight's encounter with a downdraft from a ridge shortly after takeoff resulting in a loss of lift and collision with terrain during an uncontrolled descent.Jul 5, 2013 · N1441T · Substantial damageNTSB ERA13LA300Accident · Minor injuriesLimited investigationFinal reportSikorsky 269C · Lumberton, NJThe pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing.Jun 22, 2013 · N2091E · Substantial damageNTSB ERA13FA259Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Linden, NJThe flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…May 31, 2013 · N176MA · Substantial damageNTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…May 18, 2013 · N934HA · Substantial damageNTSB DCA13FA082Accident · No injuriesField investigationFinal reportEmbraer EMB-145LR · Newark, NJthe failure of flight 908's captain to ensure adequate clearance between the wingtip of his airplane and flight 4226's empennage when he attempted to pass behind the other airplane.May 1, 2013 · N17560 · 2 aircraft · Substantial damageNTSB ERA13LA191Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Hammonton, NJA loss of control during landing due to the failure of the nose landing gear's left trunnion lug.Apr 5, 2013 · N37480 · Substantial damageNTSB ERA12IA582Incident · No injuriesIncident investigationFinal reportLearjet 60 · Teterboro, NJFailure of the nosewheel steering computer strut servo for reasons that could not be determined or replicated during postincident testing.Sep 28, 2012 · N862PA · No damageNTSB ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.Sep 21, 2012 · N7290W · Substantial damageNTSB ERA12FA563Accident · 1 fatalField investigationFinal reportAerospatiale AS 355F1 · West Windsor, NJDisconnection of the upper rod end from the fore/aft servo due to severely worn threads, which resulted in a loss of control and separation of a main rotor blade during cruise flight. Contributing to the accident were incorrect maintenance procedures and…Sep 15, 2012 · N58020 · Substantial damageNTSB ERA12LA549Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Manville, NJThe pilot’s failure to maintain directional control during the landing and attempted go-around.Sep 6, 2012 · N6716L · Substantial damageNTSB ERA12LA535Accident · 1 fatalLimited investigationFinal reportBeech 95-A55 · Millville, NJThe pilot receiving instruction failed to maintain airplane control during the simulated engine-out landing. Contributing to the accident was the flight instructor's failure to take timely remedial action.Aug 29, 2012 · N71BM · Substantial damageNTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.Aug 24, 2012 · N9055 · Substantial damageNTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.Jul 26, 2012 · N4361M · Substantial damageNTSB ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 21, 2012 · N2166G · Substantial damageNTSB ERA12LA425Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, NJThe loss of engine power during climb for reasons that could not be determined during postaccident examination of the engine and engine systems or during postaccident operational testing of the engine.Jun 29, 2012 · N449FL · Substantial damageNTSB ERA12CA427Accident · No injuriesData collectionFinal reportCessna 182A · Sussex, NJThe pilot’s delayed decision to abort the landing and perform a go-around, which resulted in a runway overrun.Jun 28, 2012 · N5143D · Substantial damageNTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.Jun 23, 2012 · N30163 · Substantial damageNTSB ERA12CA374Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Farmingdale, NJThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.May 26, 2012 · N4895A · Substantial damageNTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.Apr 15, 2012 · N965TE · Substantial damageNTSB ERA12LA287Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cross Keys, NJThe pilot's failure to maintain control of the airplane during landing, which resulted in the overstress and subsequent failure of the right main landing gear assembly.Apr 13, 2012 · N7001K · Substantial damageNTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.Mar 2, 2012 · N518F · Substantial damage