NTSB investigations, NJ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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' 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."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' 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 IAD01LA020Accident · No injuriesLimited investigationFinal reportCessna 172M · Medford, NJThe pilot's failure to attain the proper touchdown point. Factors included the loss of electrical power, the dark night, and the pilot's lack of night experience.NTSB NYC01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20J · Trenton, NJThe flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.NTSB NYC01LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe overstress separation of the control yoke from the control column.NTSB IAD01IA019Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Newark, NJa short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.NTSB NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…NTSB NYC01LA026Accident · Serious injuriesLimited investigationFinal reportDever Firefly · Berlin, NJA loss of power for undetermined reasons.NTSB IAD01IA009Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Morristown, NJThe failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.NTSB NYC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lincoln Park, NJThe pilot-in-command's failure to maintain directional control while taxiing.NTSB NYC00LA263Accident · No injuriesLimited investigationFinal reportBell 206B · North Arlington, NJThe pilot's improper decision to fly with an insufficient fuel quantity. A factor in the accident was the failure of the fuel boost pump.NTSB NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.NTSB NYC00LA253Accident · No injuriesLimited investigationFinal reportCessna 177RG · Elmer, NJThe instructor's failure to take remedial action.NTSB NYC00IA250Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJThe sequential failure of the 2nd-stage low pressure turbine nozzle locks, which allowed the 2nds stage turbine nozzle segments to rotate within the low pressure turbine case, machining a hole whereby the nozzle segments exited the engine. A factor was the…NTSB NYC00LA259Accident · No injuriesLimited investigationFinal reportMihlebach Waco · Williamstown, NJThe pilot's failure to execute an adequate flare, which resulted in a hard landing.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB NYC00LA268Accident · No injuriesLimited investigationFinal reportAerosports Connection FB-582 · Perth Amboy, NJThe pilot's failure to maintain directional control while taxiing for take off on water.NTSB DCA00MA080Accident · 11 fatalMajor investigationFinal reportPiper PA-31 Navajo · Burlington Twp., NJthe failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.NTSB NYC00LA218Accident · No injuriesLimited investigationFinal reportBeech BE-58 · West Milford, NJThe pilot's failure to maintain directional control during the landing flare and touchdown, which resulted in a blown tire, and a continued loss of directional control during the landing roll.NTSB NYC00LA214Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wildwood, NJThe partial loss of power caused by detonation of the #3 piston.NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.NTSB NYC00LA187Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wildwood, NJan improper flare by the pilot which induced an overload failure on the left side landing gear bolts. Factors were the corrosion on the bolts, and the failure of the operator to change the u-bolt in accordance with the manufacturer's recommendations.NTSB NYC00FA183Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…NTSB NYC00LA179Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Woodbine, NJThe pilot-in-command's failure to initiate a timely go-around.NTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.NTSB IAD00LA052Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Mansfield, NJThe pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.NTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.NTSB NYC00LA148Accident · No injuriesLimited investigationFinal reportBeech 19 · West Milford, NJThe pilot's failure to maintain directional control during the aborted landing.NTSB NYC00LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Williamstown, NJimproper installation of a quick drain plug by the airplane owner/mechanic which resulted in a loss of engine oil and forced landing.NTSB NYC00LA145Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Hammonton, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind condition.NTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.NTSB NYC00FA122Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJStress rupture of the 2nd-stage low pressure turbine anti-rotation nozzle locks, resulting from inadequate nozzle lock design.NTSB IAD00LA030Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Lincoln Park, NJthe pilot's failure to maintain control during landing roll. A factor was the crosswind.NTSB NYC00LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmingdale, NJThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall. A factor in the accident was the pilot's use of excessive nose-down elevator trim.NTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.NTSB IAD00LA025Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Blairstown, NJthe encountering of wind conditions in flight that inhibited the pilot from maintaining altitude.NTSB NYC00LA086Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30F · Newark, NJThe tug operator's inadequate visual lookout.NTSB NYC00LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJEngine failure due to the disconnection of the intake manifold from the #3 cylinder, as a result of improper maintenance.NTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB NYC00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Vincentown, NJThe CFI's delay in remedial action after the student pilot lost control of the airplane. A factor in the accident was the CFI's lack of total experience in flight instruction.NTSB NYC00LA061Accident · Minor injuriesLimited investigationFinal reportZielke RV-4 · Florence, NJFailure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.NTSB NYC00LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Morristown, NJThe pilot's failure to obtain proper takeoff airspeed and his failure to follow published emergency procedures. Factors related to the accident were the pilot's inadequate preflight and water contamination of the fuel system.NTSB NYC00FA047Accident · 4 fatalField investigationFinal reportBeech 58TC · Hasbrouck Hts., NJthe failure of the pilot to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin.NTSB NYC00FA039Accident · 3 fatalField investigationFinal reportBeech S35 · Newark, NJThe pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.NTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.NTSB NYC00LA005Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-11F · Newark, NJA divergent, longitudinal oscillation of undetermined origin on the center landing gear, which caused a failure of the center landing gear lower drag brace during landing roll.NTSB NYC00FA001Accident · Serious injuriesField investigationFinal reportCessna 401B · Caldwell, NJThe pilot's inadequate preflight, which resulted in an attempted takeoff with the pitot covers installed. An additional cause was the pilot's delayed decision to abort the takeoff, while factors included the misleading airspeed indications, and the proximity…NTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.NTSB NYC99LA238Accident · No injuriesLimited investigationFinal reportBeech F33A · Wildwood, NJThe pilot's improper recover from a bounced landing. A factor related to the accident was the pilot's diverted attention due to the loss of a spouse.NTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB NYC99FA213Accident · 3 fatalField investigationFinal reportCessna 172N · Sussex, NJThe pilot's improper decision to takeoff with a tailwind. Factor's in this accident were the tailwind condition and pressure to depart caused by other airplanes performing successful downwind departures.